SSpread.TypeNumberShowSep Property

Set whether to display the delimiter every 3 digits in the numeric cell.

Only valid for cells with the CellType property set to $CellTypeNumber (numeric type).
Before setting this property, use the Col , Row properties, and so on to specify what to do.

Specify $TRUE if you want to display it, or $FALSE if you do not want to display it. The initial value is $FALSE .

The delimiter for every 3 digits can be changed with the TypeNumberSeparator property.

This property is subject to property inheritance for numeric cells.

Example of use

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

Related item
CellType , TypeNumberSeparator property