SetCalText Method
Applies To
fpSpread control
Description
Sets the text for the pop-up calendar provided for date cells.
Syntax
void CSpreadSheet::SetCalText(LPCTSTR ShortDays, LPCTSTR LongDays, LPCTSTR ShortMonths, LPCTSTR LongMonths, LPCTSTR OkText, LPCTSTR CancelText);
fpSpread.SetCalText(ByVal ShortDays As String, ByVal LongDays As String, ByVal ShortMonths As String, ByVal LongMonths As String, ByVal OkText As String, ByVal CancelText As String)
Parameters
The following parameters are available:
| Parameter | Description |
|---|---|
| ShortDays | Short day names |
| LongDays | Long day names |
| ShortMonths | Short month names |
| LongMonths | Long month names |
| OkText | Text for the OK button |
| CancelText | Text for the Cancel button |
Remarks
Provide the text for the day names and month names as strings separated by the tab character (ASCII 9 or \t in C++).
This method is applied to the entire workbook, including all sheets in the control.
To display the pop-up calendar, double-click the date cell or press the F4 key (unless the you have changed the action of the F4 key using the SetActionKey method).
The settings for the SetCalText method are used as the settings for all the fpSpread controls in your application. If you provide different values for different controls, the fpSpread controls in your application will display the settings of the last call to the SetCalText method. However, you can use the SetCalTextOverride method to specify different settings for different controls.
Spread Designer
Choose the Book menu, then the Calendar Text menu, select the Calendar Text tab, and then choose an item in the Calendar Text group box in the Book Display Settings dialog, which provides items which correspond to the method parameters as specified in the following table.
| Parameter | Item on Calendar Text tab |
|---|---|
| ShortDays | Short Days option button under Calendar Text |
| LongDays | Long Days option button under Calendar Text |
| ShortMonths | Short Months option button under Calendar Text |
| LongMonths | Long Months option button under Calendar Text |
| OkText | Button Text option button under Calendar Text |
| CancelText | Button Text option button under Calendar Text |
Return Type
None
See Also
Customizing the Pop-up Calendar
GetActionKey, SetActionKey, SetCalTextOverride methods
DLL Correspondence
SSSetCalText function