SSpread.TypeCurrencyShowSep Property

Set whether to display thousands separators in currency type cells.

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

Specify $TRUE to display , $FALSE to not display . The initial value is $FALSE.

The thousands separator can be changed with the TypeCurrencySeparator property.

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

Use case

Col = 3;
Row = 2;
CellType = $CellTypeCurrency;
TypeCurrencyShowSep = $TRUE;
Value = 1000000;
 
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeCurrency;
TypeCurrencyShowSep = $FALSE;
Value = 1000000;
BlockMode = $FALSE;

Related item
CellType , TypeCurrencySeparator property