Syntax
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As DateTimeCellType Dim calFormat As String instance.SetCalendarFormat(calFormat) | |
Parameters
- calFormat
- Format of the header of the calendar
Example
This example sets the format for the date in the calendar header.
| C# | Copy Code |
|---|---|
FarPoint.Win.Spread.CellType.DateTimeCellType dt = new FarPoint.Win.Spread.CellType.DateTimeCellType(); dt.SetCalendarText(new String[] {"Sun", "Mon", "Tues", "Wed", "Thurs", "Fri", "Sat"}, new String[] {"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sept", "Oct", "Nov", "Dec"}, new String[] {"S", "M", "T", "W", "Th", "F", "Sa"}, new String[] {"J", "F", "M", "A", "M", "J", "J", "A", "S", "O", "N", "D"}, "Finished", "Later", "Now"); dt.SetCalendarFormat("MM/dd/yyyy"); fpSpread1.ActiveSheet.Cells[0, 0].CellType = dt; | |
| Visual Basic | Copy Code |
|---|---|
Dim dt As New FarPoint.Win.Spread.CellType.DateTimeCellType dt.SetCalendarText(New String() {"Sun", "Mon", "Tues", "Wed", "Thurs", "Fri", "Sat"}, New String() {"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sept", "Oct", "Nov", "Dec"}, New String() {"S", "M", "T", "W", "Th", "F", "Sa"}, New String() {"J", "F", "M", "A", "M", "J", "J", "A", "S", "O", "N", "D"}, "Finished", "Later", "Now") dt.SetCalendarFormat("MM/dd/yyyy") FpSpread1.ActiveSheet.Cells(0, 0).CellType = dt | |
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