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
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 |
|
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.