Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetOptionsView.ZeroValues Property

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

#Declaration

Delphi
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.

See Also