TdxSpreadSheetTableViewOptions.ZeroValues Property

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

Declaration

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.