DisplayZero Property (SheetView)

Gets or sets whether zero values are displayed in cells.

Syntax

Visual Basic
C#

'Declaration
 
Public Property DisplayZero As Boolean

'Usage
 
Dim instance As SheetView
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 does not allow for a cell to display a zero.

fpSpread1.ActiveSheet.DisplayZero = false;

Visual Basic

FpSpread1.ActiveSheet.DisplayZero = False

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

SheetView Class
SheetView Members

User-Task Documentation

Understanding How Cell Types Display Data