SSpread.TypeNumberDecimal Property

Set the decimal point symbol 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.

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

The number of digits after the decimal point is set with the TypeNumberDecPlaces property. The delimiter for every 3 digits is set with the TypeNumberSeparator property.

This property is subject to property inheritance for numeric cells.

Example of use

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

Related item
CellType , TypeNumberDecPlaces , TypeNumberSeparator property