Spread Windows Forms 11.0 Product Documentation
DisplayZero Property (Appearance)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Appearance Class : DisplayZero Property
Gets or sets whether zero values are displayed in cells.
Syntax
'Declaration
 
Public Property DisplayZero As Boolean
'Usage
 
Dim instance As Appearance
Dim value As Boolean
 
instance.DisplayZero = value
 
value = instance.DisplayZero
public bool DisplayZero {get; set;}

Property Value

Boolean: true to display zero; false otherwise
Example
This example sets whether to display a leading zero.
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);
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)
See Also

Reference

Appearance Class
Appearance Members