Gets or sets the value which specifies whether zero values are displayed for the specified worksheet

[Visual Basic]
Property DisplayZeros As Boolean
[C#]
bool DisplayZeros { get; set; }
[C++]
__property bool get_DisplayZeros();
__property void set_DisplayZeros(bool );
[JScript]
function get DisplayZeros() : bool
function set DisplayZeros(bool);

Property Value

True if zero values are displayed; otherwise, false. Default is true.

Example

This example sets the first sheet to hide zero values.

[C#]
book.Worksheets[1].DisplayZeros = false;

[Visual Basic]
book.Worksheets(1).DisplayZeros = False

[C++]
book->Worksheets->Item[1]->DisplayZeros = false;

See Also

IWorksheet Interface | NativeExcel Namespace

---