SSpread.TypePercentLeadingZero Property

Set the upper limit that can be input in the percentage cell.

Only valid for cells with the CellType property set to $CellTypePercent (percentage 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 percentage cells.

Example of use

Col = 3;
Row = 2;
CellType = $CellTypePercent;
TypePercentLeadingZero = $TypeLeadingZeroNo;
Value = 0.0023;
 
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypePercent;
TypePercentLeadingZero = $TypeLeadingZeroYes;
Value = 0.0045;
BlockMode = $FALSE;