ArrayFormulaCollection.Add(CellRange, String) Method

Creates a new array formula and adds it to the collection.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

ArrayFormula Add(
    CellRange range,
    string formula
)

VB.NET

Function Add(
    range As CellRange,
    formula As String
) As ArrayFormula

Parameters

Name	Type	Description
range	CellRange	A CellRange object that specifies the range to which the array formula applies.
formula	String	A string that is the array formula.

Returns

Type	Description
ArrayFormula	An ArrayFormula object that is the newly added element in the collection.