vcl-dxspreadsheetcore-dot-tdxspreadsheetoptionsview-2af046a8.md
Specifies if the Spreadsheet or Report Designer control displays formula expressions instead of their result values.
property ShowFormulas: Boolean read; write; default False;
| Type | Default |
|---|---|
| Boolean | False |
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.
See Also
TdxSpreadSheetOptionsView Class