TypeNumberShowSep Property
Applies To
fpSpread control
Description
Sets or returns whether the character used to separate groups of thousands digits (for example, the comma in "1,000") is displayed in a number cell. This property is available at run time only.
Syntax
BOOL CSpreadSheet::GetTypeNumberShowSep( );
void CSpreadSheet::SetTypeNumberShowSep(BOOL value);
[form.]fpSpread.TypeNumberShowSep[ = boolean%]
Remarks
The default value for the TypeNumberShowSep property is False, which means no separator is displayed. If the TypeNumberShowSep property is set to True, the separator designated by the TypeNumberSeparator property is used.
To use the TypeNumberShowSep 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 TypeNumberShowSep property for a cell or cells, any subsequent number cells you create will use the same TypeNumberShowSep setting unless you reset it for those cells.
The TypeNumberShowSep property does not have an effect unless the CellType property is set to 13 (Number) for the specified cell or cells.
Spread Designer
Choose the Cell menu, the Cell Type menu, the Number menu, and then the Settings tab, and then select the Show Separator check box in the Cell Type Settings dialog box.
Data Type
Integer (Boolean)
See Also
Creating and Customizing a Number Cell
Formatting a Number Cell
CellType, Sheet, TypeNumberDecimal, TypeNumberDecPlaces, TypeNumberLeadingZero, TypeNumberMax, TypeNumberMin, TypeNumberNegStyle, TypeNumberSeparator properties
DLL Correspondence
SSSetTypeNumber function