Back to Devexpress

Cell.GetDynamicArrayFormulaRange() Method

officefileapi-devexpress-dot-spreadsheet-dot-cell-2242085b.md

latest1.5 KB
Original Source

Cell.GetDynamicArrayFormulaRange() Method

Gets the entire range filled with a dynamic array formula, if the cell belongs to that range.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
CellRange GetDynamicArrayFormulaRange()
vb
Function GetDynamicArrayFormulaRange As CellRange

Returns

TypeDescription
CellRange

A range of cells filled with a dynamic array formula, or null if the current cell does not belong to that range.

|

Remarks

Use the GetArrayFormulaRange method to change the dynamic array formula for a specific cell. Cal the GetArrayFormulaRange method to get the range. Then, use the CellRange.ArrayFormula property to obtain or set a new array formula. You can modify the formula for the entire range only.

See Also

Cell Interface

Cell Members

DevExpress.Spreadsheet Namespace