Link Search Menu Expand Document

SSpread.TypeCurrencyDecPlaces Property

In the currency cell, set the number of digits to display after the decimal point.

Only valid for cells with the CellType property set to $CellTypeCurrency (currency type). Before setting this property, use the Col , Row properties etc. to specify what you want to process.

You can specify 0 to 14 . The initial value is 2 (digits).

This property is subject to property inheritance of currency type cells.

Example of use

Col = 3;
Row = 2;
CellType = $ CellTypeCurrency;
TypeCurrencyDecPlaces = 3;
Value = 1.23;
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeCurrency;
TypeCurrencyDecPlaces = 1;
Value = 4.56;
BlockMode = $ FALSE;

Related item
CellType property