Page History

Description

Excerpt
Sets or returns whether zero values in cells will be displayed in the worksheet. Zero values are displayed by default.

Signature

	C#
	C#

<p>  public boolean ShowZeroValues{ get; set; }
</p>

Signature

	vb.net
	vb.net

<p>Public Public Property ShowZeroValues() As Boolean
Boolean</p>

Example

Code Block

...

//--- Get ShowZeroValues
          bool showZeroes = ws.ShowZeroValues;

          //--- Set ShowZeroValues
          ws.ShowZeroValues = true;

Code Block

...

'--- Get ShowZeroValues
          Dim showZeros As Boolean = ws.ShowZeroValues

          '--- Set ShowZeroValues
          ws.ShowZeroValues = True

Versions Compared