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

TdxSpreadSheetOptionsView.ShowFormulas Property

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

#Declaration

Delphi
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:

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