FarPoint.Win.Spread
LeadingZero Enumeration
Example  See Also 
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace : LeadingZero Enumeration


Specifies whether to display leading zeros in numeric cell types.

Syntax

Visual Basic (Declaration) 
Public Enum LeadingZero 
   Inherits Enum
Visual Basic (Usage)Copy Code
Dim instance As LeadingZero
C# 
public enum LeadingZero : Enum

Members

MemberDescription
UseRegional Displays leading zeros according to the Windows regional settings
No Does not display leading zeros
Yes Displays leading zeros

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 BasicCopy 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

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.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.CellType.LeadingZero

See Also