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

Glossary Item Box

TypeCurrencyShowSymbol Property


See Also    DLL    Example 1    Example 2

Applies To

fpSpread control

Description

Sets or returns whether a currency symbol displays in a currency cell. This property is available at run time only.

Syntax

C++

BOOL CSpreadSheet::GetTypeCurrencyShowSymbol( );
void CSpreadSheet::SetTypeCurrencyShowSymbol(BOOL value);

Visual Basic

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

Remarks

The default value for the TypeCurrencyShowSymbol property is True, which means the symbol designated by the TypeCurrencySymbol property is used. If the TypeCurrencyShowSymbol property is set to False, the currency symbol is not displayed.

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

The TypeCurrencyShowSymbol 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 Currency check box in the Cell Type Settings dialog box.

Data Type

Integer (Boolean)

See Also

Formatting a Currency Cell

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

DLL Correspondence

SSSetTypeCurrencyEx function

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