TdxSpreadSheetOptionsView.ZeroValues Property

Specifies if zero values can be displayed by the cells objects with defined names, references or formula expressions.

Declaration

property ZeroValues: Boolean read; write; default True;

Property Value

Type	Default
Boolean	True

Remarks

Use this property to determine how the Spreadsheet control displays references to empty cells and formula expressions whose resulting value is zero. If the ZeroValues property is True, the cells containing formulas display zeros. Otherwise, these cells are blank as if nothing is contained within them.

Note

Each individual Table View worksheet has its own zero result value display setting represented by its Options.ZeroValues property, which has priority over the “global” ZeroValues property.

The default value of the ZeroValues property is True.