TdxSpreadSheetOptionsView.ShowFormulas Property

Specifies if the Spreadsheet or Report Designer control displays formula expressions instead of their result values.

Declaration

property ShowFormulas: Boolean read; write; default False;

Property Value

Type	Default
Boolean	False

Remarks

The control displays formula source text within formula cells instead of calculated results in the active worksheet if one of the following conditions is met:

• The ShowFormulas property is set to True and the worksheet’s Options.ShowFormulas property is set to bDefault;

• The worksheet’s Options.ShowFormulas property is set to bTrue.

Cells display calculated formula results by default:

The Options.ShowFormulas property values of individual worksheets within a spreadsheet document always have priority over the “global” ShowFormulas property. For instance, if the worksheet’s Options.ShowFormulas property is not set to bDefault, the ShowFormulas property has no effect. Refer to the TdxSpreadSheetTableViewOptions.ShowFormulas property description for additional information.

The default value of the ShowFormulas property is False.