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