SSpread.TypeCurrencyDecimal Property

Set the decimal point symbol in the currency cell.

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 do.

The initial value is a blank string ( according to OS settings).

Set the number of decimal places with the TypeCurrencyDecPlaces property.
Set the thousands separator with the TypeCurrencySeparator property and the currency symbol with the TypeCurrencySymbol property.

This property is subject to property inheritance of currency cells.

Example of use

Col = 3;
Row = 2;
CellType = $CellTypeCurrency;
TypeCurrencyDecimal = "・";
Value = 1.23;
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeCurrency;
TypeCurrencyDecimal = ",";
Value = 4.56;
BlockMode = $ FALSE;

Related item
CellType , TypeCurrencyDecPlaces , TypeCurrencySeparator , TypeCurrencySymbol properties