Skip to main content

IXlSheetViewOptions.ShowFormulas Property

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

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

bool ShowFormulas { get; set; }

Property Value

Type Description
Boolean

true, to display formulas; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type Path to ShowFormulas
IXlSheet
.ViewOptions .ShowFormulas

Remarks

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

This property value also 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