Spread 8.0 Documentation
TypeNumberShowSep Property
Support Options
ActiveX Reference > ActiveX Properties > TypeNumberShowSep Property

Glossary Item Box

TypeNumberShowSep Property


See Also    DLL    Example

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

C++

BOOL CSpreadSheet::GetTypeNumberShowSep( );
void CSpreadSheet::SetTypeNumberShowSep(BOOL value);

Visual Basic

[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

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