wpf-devexpress-dot-xpf-dot-spreadsheet-dot-spreadsheetcapabilitiesoptions-8964a214.md
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.v25.2.dll
NuGet Package : DevExpress.Wpf.Spreadsheet
public DocumentCapability Formulas { get; set; }
Public Property Formulas As DocumentCapability
| 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.
|
You can access this nested property as listed below:
| Object Type | Path to Formulas |
|---|---|
| SpreadsheetControlOptions |
.DocumentCapabilities .Formulas
|
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
SpreadsheetCapabilitiesOptions Class