SSpread.TypeNumberSeparator Property

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

Show / hide the delimiter is set with the TypeNumberShowSep property. The decimal point symbol is set with the TypeNumberDecimal property.

The initial value is a blank character string ( according to the OS setting value).

This property is subject to property inheritance for numeric cells.

Example of use

Col = 3;
Row = 2;
CellType = $ CellTypeNumber;
TypeNumberShowSep = $ TRUE;
TypeNumberSeparator = " , ";
Value = 1234.56;
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeNumber;
TypeNumberSeparator = ".";
TypeNumberDecimal = ",";
Value = 1000000;
BlockMode = $ FALSE;

Related item
CellType , TypeNumberDecimal , TypeNumberShowSep property