WorkbookCapabilitiesOptions.Formulas Property
Gets or sets the document’s capability to load, insert, modify and export formulas.
Namespace: DevExpress.XtraSpreadsheet
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
[DefaultValue(DocumentCapability.Default)]
public DocumentCapability Formulas { get; set; }Property Value
| Type | Default | Description |
|---|---|---|
| DocumentCapability | Default | 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 |
|---|---|
| DocumentOptions |
|
Remarks
Use this property to import or export only formula values from XLSX and XLS files. To do that, set the Formulas property to DocumentCapability.Disabled before importing/exporting the document (e.g., in the SpreadsheetControl.BeforeImport or SpreadsheetControl.BeforeExport event handler).
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.