TdxSpreadSheetTableViewOptions.ShowFormulas Property

Specifies whether a cell object displays a formula expression instead of its calculated result.

Declaration

property ShowFormulas: TdxDefaultBoolean read; write; default bDefault;

Property Value

Type	Default
TdxDefaultBoolean	bDefault

Remarks

This property corresponds to the worksheet-level formula display setting. Visibility of formula expressions instead of their calculated values in a particular Table View worksheet is determined by both the ShowFormulas property value and the Spreadsheet control‘s OptionsView.ShowFormulas property value:

The OptionsView.ShowFormulas Property Value	The ShowFormulas Property Value
	bFalse	bTrue	bDefault
True	A calculated result is displayed by a cell object with formula.	A formula expression is displayed instead of its calculated result.	A formula expression is displayed instead of its calculated result.
False	A calculated result is displayed by a cell object with a formula.	A formula expression is displayed instead of its calculated result.	A calculated result is displayed by a cell object with a formula.

The image below displays a Table View worksheet whose B2 cell contains a formula that subtracts the values of the A2 and B1 cells from the A1 cell value. In this instance, the ShowFormulas property is set to bTrue.

After setting the ShowFormulas property to bFalse, the resulting value will be displayed within the B2 cell instead of formula it contains.

To identify whether the formula expressions are displayed instead of their calculated values in a particular Table View worksheet, use the ActualShowFormulas property.

The default value of the ShowFormulas property is bDefault.