Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

SpreadsheetCapabilitiesOptions.Formulas Property

Gets or sets the document’s capability to load, create, modify and export formulas. This is a dependency property.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v24.2.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

#Declaration

public DocumentCapability Formulas { get; set; }

#Property Value

Type Description
DocumentCapability

A DocumentCapability enumeration value specifying the document’s capability to perform an operation.

Available values:

Name Description
Default

The value is determined by the current setting. The default value is automatically set if it is not explicitly specified.

Disabled

The feature is not allowed and the corresponding commands are shown disabled.

Enabled

The feature is available and the corresponding commands are shown enabled.

Hidden

The feature is not available and the corresponding commands are hidden.

#Property Paths

You can access this nested property as listed below:

Object Type Path to Formulas
SpreadsheetControlOptions

#Remarks

You can use the Formulas property to import/export only formula values from/to the XLSX or XLS file. To do this, set the Formulas property to DocumentCapability.Disabled before importing/exporting a document.

The DocumentCapability.Default property value for the Formulas is equal to the DocumentCapability.Enabled, so that the formulas are available for the Spreadsheet document by default.

See Also