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

Glossary Item Box

TypeCurrencyShowSep Property


See Also    DLL    Example 1    Example 2

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 currency cell. This property is available at run time only.

Syntax

C++

BOOL CSpreadSheet::GetTypeCurrencyShowSep( );
void CSpreadSheet::SetTypeCurrencyShowSep(BOOL value);

Visual Basic

[form.]fpSpread.TypeCurrencyShowSep[ = boolean%]

Remarks

The default value for the TypeCurrencyShowSep property is False, which means no separator is displayed. If the TypeCurrencyShowSep property is set to True, the separator designated by the TypeCurrencySeparator property is used.

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

The TypeCurrencyShowSep property does not have an effect unless the CellType property is set to 12 (Currency) for the specified cell or cells.

Spread Designer

Choose the Cell menu, the Cell Type menu, the Currency 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 Currency Cell
Formatting a Currency Cell

CellType, Sheet, TypeCurrencyDecimal, TypeCurrencyDecPlaces, TypeCurrencyLeadingZero, TypeCurrencyMax, TypeCurrencyMin, TypeCurrencyNegStyle, TypeCurrencyPosStyle, TypeCurrencySeparator, TypeCurrencyShowSymbol, TypeCurrencySymbol properties

DLL Correspondence

SSSetTypeCurrency function

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