Gets or sets dimensions of the drop-down calendar.

Syntax

Visual Basic (Declaration)
Public Property CalendarDimensions As Size

Visual Basic (Usage)	Copy Code
Dim instance As DropDownCalendar Dim value As Size instance.CalendarDimensions = value value = instance.CalendarDimensions

C#
public Size CalendarDimensions {get; set;}

Property Value

A System.Drawing.Size with the number of columns and rows to use to display the calendar.
The default is true.

Exceptions

Exception	Description
System.ArgumentException	The value is not valid.

Remarks

Only one calendar year is displayed at a time, and the maximum number of months that can be displayed is 12. Valid combinations of columns and rows have a maximum product of 12; values greater than 12 are not allowed.

Example

This example uses the CalendarDimensions property.

C#	Copy Code
GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType datecell = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType(); fpSpread1.Sheets[0].Cells[0, 0].CellType = datecell; datecell.DropDownCalendar.BackColor = Color.Red; datecell.DropDownCalendar.CalendarDimensions = new Size(3, 1); datecell.DropDownCalendar.Font = new Font("Arial", 10, FontStyle.Bold); datecell.DropDown.AllowDrop = true; datecell.DropDown.AllowResize = true; datecell.DropDown.AutoDropDown = true; datecell.DefaultActiveField = datecell.Fields[2];

Copy Code

GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType datecell = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType();
fpSpread1.Sheets[0].Cells[0, 0].CellType = datecell;
datecell.DropDownCalendar.BackColor = Color.Red;
datecell.DropDownCalendar.CalendarDimensions = new Size(3, 1);
datecell.DropDownCalendar.Font = new Font("Arial", 10, FontStyle.Bold);
datecell.DropDown.AllowDrop = true;
datecell.DropDown.AllowResize = true;
datecell.DropDown.AutoDropDown = true;
datecell.DefaultActiveField = datecell.Fields[2];

VB.NET	Copy Code
Dim datecell As New GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType() FpSpread1.Sheets(0).Cells(0, 0).CellType = datecell datecell.DropDownCalendar.BackColor = Color.Red datecell.DropDownCalendar.CalendarDimensions = New Size(3, 1) datecell.DropDownCalendar.Font = New Font("Arial", 10, FontStyle.Bold) datecell.DropDown.AllowDrop = True datecell.DropDown.AllowResize = True datecell.DropDown.AutoDropDown = True datecell.DefaultActiveField = datecell.Fields(2)

VB.NET

Copy Code

Dim datecell As New GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType()
FpSpread1.Sheets(0).Cells(0, 0).CellType = datecell
datecell.DropDownCalendar.BackColor = Color.Red
datecell.DropDownCalendar.CalendarDimensions = New Size(3, 1)
datecell.DropDownCalendar.Font = New Font("Arial", 10, FontStyle.Bold)
datecell.DropDown.AllowDrop = True
datecell.DropDown.AllowResize = True
datecell.DropDown.AutoDropDown = True
datecell.DefaultActiveField = datecell.Fields(2)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8