TypeTimeSeparator Property

Applies To

fpSpread control

Description

Sets or returns the character used to separate the hours, minutes, and seconds in a time cell. This property is available at run time only.

Syntax

C++

short CSpreadSheet::GetTypeTimeSeparator( );
void CSpreadSheet::SetTypeTimeSeparator(short value);

Visual Basic

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

Remarks

The default value for the TypeTimeSeparator property is 0, which specifies to use the value in the Time 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.

Use the ASCII value of the character to specify the time separator character.

To use the TypeTimeSeparator 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 TypeTimeSeparator property for a cell or cells, any subsequent time cells you create will use the same TypeTimeSeparator setting unless you reset it for those cells.

The TypeTimeSeparator property does not have an effect unless the CellType property is set to 6 (Time) for the specified cell or cells.

Spread Designer

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

Data Type

Integer

DLL Correspondence

SSSetTypeTime function