Reference>IXLSWorksheet>DisplayZeros

Returms or sets the value which specifies whether zero values are displayed for the specified Worksheet. Read/write Boolean.

Syntax

property DisplayZeros: boolean;

This example toggles the display of zero values in the first sheet.

Workbook.Sheets[1].DisplayZeros := not(Workbook.Sheets[1].DisplayZeros);