.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

WorksheetView.ShowFormulas Property

Gets or sets whether to display the formula in each cell instead of the formula result.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.1.Core.dll


bool ShowFormulas { get; set; }

Property Value

Type Description

true, to display formulas; otherwise, false.


The ShowFormulas property allows you to toggle between displaying formulas and formula results on the current worksheet only. Note that this property does not change the state of cells, only the way they are displayed.

This property value is saved to a document and influences how the worksheet is previewed and printed. The printed document will contain the full formula expression instead of the calculated result for each formula in the worksheet whose ShowFormulas property is set to true.

See Also