Spread Windows Forms 11.0 Product Documentation
SetCalendarFormat Method
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > DateTimeCellType Class : SetCalendarFormat Method
Format of the header of the calendar
Sets the format to be used for the pop-up calendar header.
Syntax
'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;
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
See Also

Reference

DateTimeCellType Class
DateTimeCellType Members