Back to Devexpress

ArrayFormulaCollection.Add(CellRange, String) Method

officefileapi-devexpress-dot-spreadsheet-dot-arrayformulacollection-dot-add-x28-devexpress-dot-spreadsheet-dot-cellrange-system-dot-string-x29.md

latest1.7 KB
Original Source

ArrayFormulaCollection.Add(CellRange, String) Method

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

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
ArrayFormula Add(
    CellRange range,
    string formula
)
vb
Function Add(
    range As CellRange,
    formula As String
) As ArrayFormula

Parameters

NameTypeDescription
rangeCellRange

A CellRange object that specifies the range to which the array formula applies.

| | formula | String |

A string that is the array formula.

|

Returns

TypeDescription
ArrayFormula

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

|

See Also

ArrayFormulaCollection Interface

ArrayFormulaCollection Members

DevExpress.Spreadsheet Namespace