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

TdxSpreadSheetTableViewOptions.ZeroValues Property

Specifies whether zero values are displayed in the cell objects with formula expressions.

#Declaration

Delphi
property ZeroValues: TdxDefaultBoolean read; write; default bDefault;

#Property Value

Type Default
TdxDefaultBoolean bDefault

#Remarks

This property corresponds to the worksheet-level zero formula result display setting. The visibility of calculated zero results is determined by both the ZeroValues property value and the Spreadsheet control‘s OptionsView.ZeroValues property value:

The OptionsView.ZeroValues Property Value

The ZeroValues Property Value

bFalse

bTrue

bDefault

True

The calculated zero results are not displayed.

The calculated zero results are shown in cells.

The calculated zero results are shown in cells.

False

The calculated zero results are not displayed.

The calculated zero results are shown in cells.

The calculated zero results are not displayed.

To identify whether the calculated zero values are displayed in a particular Table View worksheet, use the ActualZeroValues property.

The default value of the ZeroValues property is bDefault.

See Also