Link Search Menu Expand Document

SSpread.TypeNumberDecPlaces Property

In the numeric cell, set the number of digits to display after the decimal point.

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.

You can specify 0 to 14 . The initial value is 2 (digits).

This property is subject to property inheritance for numeric cells.

Example of use

Col = 3;
Row = 2;
CellType = $ CellTypeNumber;
TypeNumberDecPlaces = 3;
Value = 1.23;
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeNumber;
TypeNumberDecPlaces = 1;
Value = 4.56;
BlockMode = $ FALSE;
 

Related item
CellType property