Gets or sets whether zero values are displayed in cells
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property DisplayZero As Boolean |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Appearance
Dim value As Boolean
instance.DisplayZero = value
value = instance.DisplayZero |
| C# | |
|---|
public bool DisplayZero {get; set;} |
Property Value
Boolean:
true to display zero;
false otherwise
Example
This example sets whether to display a leading zero.
| C# | Copy Code |
|---|
FarPoint.Win.Spread.Appearance appr = new FarPoint.Win.Spread.Appearance();
appr.DisplayZero = false;
appr.FilterState = FilterState.None;
appr.MouseOver = true;
appr.RightToLeft = false;
appr.ShowActive = true;
appr.SortState = SortState.None;
appr.VisualStyles = FarPoint.Win.VisualStyles.On;
FarPoint.Win.Spread.StyleInfo si = new FarPoint.Win.Spread.StyleInfo();
si.SetAppearance(appr);
fpSpread1.ActiveSheet.SetStyleInfo(0, 0, si); |
| Visual Basic | Copy Code |
|---|
Dim appr As New FarPoint.Win.Spread.Appearance()
appr.DisplayZero = False
appr.FilterState = FilterState.None
appr.MouseOver = True
appr.RightToLeft = False
appr.ShowActive = True
appr.SortState = SortState.None
appr.VisualStyles = FarPoint.Win.VisualStyles.On
Dim si As New FarPoint.Win.Spread.StyleInfo
si.SetAppearance(appr)
FpSpread1.ActiveSheet.SetStyleInfo(0, 0, si) |
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
See Also
