officefileapi-devexpress-dot-xtraspreadsheet-dot-workbookcapabilitiesoptions-521009de.md
Gets or sets the document’s capability to load, insert, modify, and export dynamic array formulas.
Namespace : DevExpress.XtraSpreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
[DefaultValue(DocumentCapability.Default)]
public DocumentCapability DynamicArrayFormulas { get; set; }
<DefaultValue(DocumentCapability.Default)>
Public Property DynamicArrayFormulas As DocumentCapability
| Type | Default | Description |
|---|---|---|
| DocumentCapability | Default |
An enumeration value that specifies the document’s ability 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 DynamicArrayFormulas |
|---|---|
| DocumentOptions |
.DocumentCapabilities .DynamicArrayFormulas
|
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
WorkbookCapabilitiesOptions Class