Spread 8.0 Documentation
SetCalText Method
Support Options
ActiveX Reference > ActiveX Methods > SetCalText Method

Glossary Item Box

SetCalText Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets the text for the pop-up calendar provided for date cells.

Syntax

C++

void CSpreadSheet::SetCalText(LPCTSTR ShortDays, LPCTSTR LongDays, LPCTSTR ShortMonths, LPCTSTR LongMonths, LPCTSTR OkText, LPCTSTR CancelText);

Visual Basic

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

Copyright © GrapeCity, inc. All rights reserved.