TypeDateSeparator Property

Applies To

fpSpread control

Description

Sets or returns the separator used between the month, day, and year in a date cell. This property is available at run time only.

Syntax

C++

short CSpreadSheet::GetTypeDateSeparator( );
void CSpreadSheet::SetTypeDateSeparator(short value);

Visual Basic

[form.]fpSpread.TypeDateSeparator[ = value%]

Remarks

The default value for the TypeDateSeparator property is 0, which specifies to use the value in the Date Format setting in the Windows Control Panel.

Note: The control does not recognize changes made to the Windows regional settings or options until you restart your development environment or your application (or perform any operation that unloads and reloads the current control files). For more information about regional settings or options and Windows operating environments, see Variations in Windows Regional Settings or Options.

To use the TypeDateSeparator property, specify the sheet with which you want to work by setting the Sheet property. Then specify the cell or cells to which to apply the property, as described in Using Column and Row Properties. Once you set the TypeDateSeparator property for a cell or cells, any subsequent date cells you create will use the same TypeDateSeparator setting unless you reset it for those cells.

The TypeDateSeparator property does not have an effect unless the CellType property is set to 0 (Date) for the specified cell or cells.

Specify the format of the date displayed in the cell by setting the TypeDateFormat property.

Spread Designer

Choose the Cell menu, the Cell Type menu, the Date menu, and then the Settings tab, and then type a value in the Separator edit box in the Cell Type Settings dialog box.

Data Type

Integer

DLL Correspondence

SSSetTypeDate function