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

Declaration

C#

bool ShowFormulas { get; set; }

VB.NET

Property ShowFormulas As Boolean

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.