SetCalendarFormat Method

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

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

C#

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

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

Reference

DateTimeCellType Class
DateTimeCellType Members