DynamicArrayFormulaCollection.Add(CellRange, String) Method

Adds a new dynamic array formula to the collection.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

DynamicArrayFormula Add(
    CellRange range,
    string formula
)

VB.NET

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

Parameters

Name	Type	Description
range	CellRange	The range to which the array formula applies.
formula	String	The dynamic array formula.

Returns

Type	Description
DynamicArrayFormula	The newly added formula.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Add(CellRange, String) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

spreadsheet-document-api-examples-part1/CS/SpreadsheetExamples/SpreadsheetActions/FormulaActions.cs#L265

worksheet["A2"].DynamicArrayFormulaInvariant = "={\"Red\",\"Green\",\"Orange\",\"Blue\"}";
worksheet.DynamicArrayFormulas.Add(worksheet["B1"], "=LEN(A2:D2)");
#endregion #DynamicArrayFormulas

winforms-spreadsheetcontrol-api-part1/CS/SpreadsheetControl/SpreadsheetActions/FormulaActions.cs#L314

worksheet["A2"].DynamicArrayFormulaInvariant = "={\"Red\",\"Green\",\"Orange\",\"Blue\"}";
worksheet.DynamicArrayFormulas.Add(worksheet["B1"], "=LEN(A2:D2)");
#endregion #DynamicFormulas

VB.NET

spreadsheet-document-api-examples-part1/VB/SpreadsheetExamples/SpreadsheetActions/FormulaActions.vb#L214

            worksheet("A2").DynamicArrayFormulaInvariant = "={""Red"",""Green"",""Orange"",""Blue""}"
            worksheet.DynamicArrayFormulas.Add(worksheet("B1"), "=LEN(A2:D2)")
#End Region  ' #ArrayFormulas

winforms-spreadsheetcontrol-api-part1/VB/SpreadsheetControl/SpreadsheetActions/FormulaActions.vb#L286

worksheet("A2").DynamicArrayFormulaInvariant = "={""Red"",""Green"",""Orange"",""Blue""}"
worksheet.DynamicArrayFormulas.Add(worksheet("B1"), "=LEN(A2:D2)")
'                #End Region ' #DynamicFormulas