HotXLS Delphi Excel Read Write Library / Component Developers Guide loslab Inc.
Reference > IXLSWorksheet > DisplayZeros

DisplayZeros property

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

Syntax

property DisplayZeros: boolean;

Example

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

Workbook.Sheets[1].DisplayZeros := not(Workbook.Sheets[1].DisplayZeros);
Copyright©2007-2019 loslab.com