FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace : LeadingZero Enumeration |
'Declaration Public Enum LeadingZero Inherits System.Enum
'Usage Dim instance As LeadingZero
public enum LeadingZero : System.Enum
Member | Description |
---|---|
No | Does not display leading zeros |
UseRegional | Displays leading zeros according to the Windows regional settings |
Yes | Displays leading zeros |
Do not use the UseRegional setting: it is intended for future use to display leading zeros according to the Windows regional settings, but this setting is not implemented at this time.
For those properties that use this setting as a default, the default value is instead 1 (No), which specifies that no leading zero is displayed.
FarPoint.Win.Spread.CellType.NumberCellType numct = new FarPoint.Win.Spread.CellType.NumberCellType();
numct.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.Yes;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = numct;
fpSpread1.ActiveSheet.Cells[0, 0].Value = 0.456;
Dim numct As New FarPoint.Win.Spread.CellType.NumberCellType() numct.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.Yes FpSpread1.ActiveSheet.Cells(0, 0).CellType = numct FpSpread1.ActiveSheet.Cells(0, 0).Value = 0.456
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.CellType.LeadingZero
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8