.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+

WorkbookCapabilitiesOptions.Formulas Property

Gets or sets the document's capability to load, insert, modify and export formulas.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

[DefaultValue(DocumentCapability.Default)]
public DocumentCapability Formulas { get; set; }
<DefaultValue(DocumentCapability.Default)>
Public Property Formulas As DocumentCapability
[DefaultValue(DocumentCapability.Default)]
public DocumentCapability Formulas { get; set; }
<DefaultValue(DocumentCapability.Default)>
Public Property Formulas As DocumentCapability
[DefaultValue(DocumentCapability.Default)]
public DocumentCapability Formulas { get; set; }
<DefaultValue(DocumentCapability.Default)>
Public Property Formulas As DocumentCapability

Property Value

Type Default Description
DocumentCapability

Default

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

Property Value

Type Default Description
DocumentCapability

Default

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

Property Value

Type Default Description
DocumentCapability

Default

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

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.

See Also