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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

CellRange GetArrayFormulaRange()

Function GetArrayFormulaRange As CellRange

Returns

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

IsTopLeftCellInArrayFormulaRange

Array Formulas in Spreadsheet for WinForms

Cell Interface

Cell Members

DevExpress.Spreadsheet Namespace