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

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

Declaration

CellRange GetArrayFormulaRange()

Returns

Type Description
CellRange

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

Remarks

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