TypeCurrencyDecPlaces Property
Applies To
fpSpread control
Description
Sets or returns the number of digits allowed to the right of the decimal point in a currency cell. This property is available at run time only.
Syntax
short CSpreadSheet::GetTypeCurrencyDecPlaces( );
void CSpreadSheet::SetTypeCurrencyDecPlaces(short value);
[form.]fpSpread.TypeCurrencyDecPlaces[ = value%]
Remarks
The default value for the TypeCurrencyDecPlaces property is two decimal places. The maximum total number of numerals in the cell is 14.
To use the TypeCurrencyDecPlaces 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 TypeCurrencyDecPlaces property for a cell or cells, any subsequent currency cells you create will use the same TypeCurrencyDecPlaces setting unless you reset it for those cells.
The TypeCurrencyDecPlaces property does not have an effect unless the CellType property is set to 12 (Currency) for the specified cell or cells.
You can specify a different character to display as the decimal point by setting the TypeCurrencyDecimal property.
Spread Designer
Choose the Cell menu, the Cell Type menu, the Currency menu, and then the Settings tab, and then type a number in the Decimal Places edit box in the Cell Type Settings dialog box.
Data Type
Integer
See Also
Creating and Customizing a Currency Cell
CellType, Sheet, TypeCurrencyDecimal, TypeCurrencyLeadingZero, TypeCurrencyMax, TypeCurrencyMin, TypeCurrencyNegStyle, TypeCurrencyPosStyle, TypeCurrencySeparator, TypeCurrencyShowSep, TypeCurrencyShowSymbol, TypeCurrencySymbol properties
DLL Correspondence
SSSetTypeCurrencyEx function