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.v19.2.dll
Declaration
Property Value
Type | Description |
---|---|
DocumentCapability | A DocumentCapability enumeration value specifying the document’s capability to perform an operation. |
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