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
NuGet Package: DevExpress.Spreadsheet.Core
NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core
Declaration
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.