Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum LeadingZero Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As LeadingZero | |
| C# | |
|---|---|
public enum LeadingZero : System.Enum | |
Members
| Member | Description |
|---|---|
| No | Does not display leading zeros |
| UseRegional | Displays leading zeros according to the Windows regional settings |
| Yes | Displays leading zeros |
Remarks
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.
Example
This example shows how to display the leading zero in a numeric cell.
| C# | Copy Code |
|---|---|
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; | |
| Visual Basic | Copy Code |
|---|---|
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 | |
Inheritance Hierarchy
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.CellType.LeadingZero
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2