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.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

CellRange GetDynamicArrayFormulaRange()

VB.NET

Function GetDynamicArrayFormulaRange As CellRange

Returns

Type	Description
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.