.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

Cell.GetArrayFormulaRange() Method

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

Namespace: DevExpress.Spreadsheet

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


CellRange GetArrayFormulaRange()


Type Description

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


Use the GetArrayFormulaRange method if your objective is to modify the array formula for a certain cell. An array formula can be modified for the entire range only, so you have to get the range via the GetArrayFormulaRange method and then use the CellRange.ArrayFormula property to get an array formula or to specify a new array formula.

See Also