SSpread.TypeCurrencySeparator Property

Set the thousands separator in currency type cells.

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.

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

Show / hide the delimiter is set with the TypeCurrencyShowSep property. Set the decimal symbol with the TypeCurrencyDecimal property and the currency symbol with the TypeCurrencySymbol property.

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

Use case

Col = 3;
Row = 2;
CellType = $CellTypeCurrency;
TypeCurrencyShowSep = $TRUE;
TypeCurrencySeparator = "，";
Value = 1234.56;
 
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeCurrency;
TypeCurrencySeparator = ".";
TypeCurrencyDecimal = ",";
Value = 1000000;
BlockMode = $FALSE;

Related item
CellType , TypeCurrencyDecimal , TypeCurrencyShowSep , TypeCurrencySymbol property