DisplayZero Property (Appearance)

Gets or sets whether zero values are displayed in cells.

Syntax

Visual Basic
C#

'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);

Visual Basic

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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

Appearance Class
Appearance Members