.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

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.v19.2.Core.dll

Declaration

bool ShowFormulas { get; set; }
Property ShowFormulas As Boolean
bool ShowFormulas { get; set; }
Property ShowFormulas As Boolean
bool ShowFormulas { get; set; }
Property ShowFormulas As Boolean

Property Value

Type Description
Boolean

true, to display formulas; otherwise, false.

Property Value

Type Description
Boolean

true, to display formulas; otherwise, false.

Property Value

Type Description
Boolean

true, to display formulas; otherwise, false.

Remarks

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