SetCalendarFormat Method

Sets the format to be used for the pop-up calendar header.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub SetCalendarFormat( _
   ByVal calFormat As String _
)

'Usage
 
Dim instance As DateTimeCellType
Dim calFormat As String
 
instance.SetCalendarFormat(calFormat)

public void SetCalendarFormat( 
   string calFormat
)

Parameters

calFormat: Format of the header of the calendar

Example

This example sets the format for the date in the calendar header.

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

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

Reference

DateTimeCellType Class
DateTimeCellType Members