Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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

NuGet Package: DevExpress.Spreadsheet.Core

#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