SSpread.TypeNumberLeadingZero Property

Sets whether to display leading zeros in numeric cells.

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 the following values. The initial value is $ TypeLeadingZeroIntl .

Constant	Value	Explanation
$ TypeLeadingZeroIntl	0	Follow OS settings
$ TypeLeadingZeroNo	1	Hide
$ TypeLeadingZeroYes	2	Display

This property specifies whether to display zeros in the integer part for decimal values between -1.0 and 1.0 .

For example , at -0.5 , it will be “ -0.5 “ if it is displayed, and “ -.5 “ if it is not displayed .

This property is subject to property inheritance for numeric cells.

Example of use

Col = 3;
Row = 2;
CellType = $ CellTypeNumber;
TypeNumberLeadingZero = $ TypeLeadingZeroNo;
Value = 0.23;
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeNumber;
TypeNumberLeadingZero = $ TypeLeadingZeroYes;
Value = 0.45;
BlockMode = $ FALSE;
 