SSpread.TypeCurrencyLeadingZero Property

Sets whether to display leading zeros in currency cells.

Only valid for cells with the CellType property set to $CellTypeCurrency (currency type). Before setting this property, use the Col , Row properties etc. to specify what you want to process.

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 , -0.5 means “ -0.5 “ to show and “ -.5 “ to not show .

This property is subject to property inheritance of currency type cells.

Example of use

Col = 3;
Row = 2;
CellType = $CellTypeCurrency;
TypeCurrencyLeadingZero = $ TypeCurrencyLeadingZeroNo;
Value = 0.23;
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeCurrency;
TypeCurrencyLeadingZero = $TypeLeadingZeroYes;
Value = 0.45;
BlockMode = $ FALSE;