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

Glossary Item Box

SetCalTextOverride Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets the text for the pop-up calendar provided for date cells in a specific fpSpread control.

Syntax

C++

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

Visual Basic

fpSpread.SetCalTextOverride(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 SetCalTextOverride method are used as the settings for the fpSpread control you specify in the method call. Use the SetCalText method if you want to specify the same calendar text for all the fpSpread controls in your application.

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

GetCalTextOverride, SetActionKey, SetCalText methods

DLL Correspondence

SSSetCalTextOverride function

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.