All docs
V19.2
19.2
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

CellRange.HasArrayFormula Property

Determines whether the current cell or cell range intersects a range filled with an array formula.

Namespace: DevExpress.Spreadsheet

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

Declaration

bool HasArrayFormula { get; }
ReadOnly Property HasArrayFormula As Boolean
bool HasArrayFormula { get; }
ReadOnly Property HasArrayFormula As Boolean
bool HasArrayFormula { get; }
ReadOnly Property HasArrayFormula As Boolean

Property Value

Type Description
Boolean

true, if the current range intersects an array formula range; otherwise, false.

Property Value

Type Description
Boolean

true, if the current range intersects an array formula range; otherwise, false.

Property Value

Type Description
Boolean

true, if the current range intersects an array formula range; otherwise, false.

Remarks

An array formula is a special kind of formula used to perform calculations with arrays of cells. For detailed information, see the Array Formulas topic.

Examples

This example demonstrates how to create an array formula.

// Create an array formula that multiplies values contained in the cell range A2 through A11 
// by the corresponding cells in the range B2 through B11, 
// and displays the results in cells C2 through C11.
worksheet.Range.FromLTRB(2,1,2,10).ArrayFormula = "=A2:A11*B2:B11";

// Create an array formula that multiplies values contained in the cell range C2 through C11 by 2
// and displays the results in cells D2 through D11.
worksheet.Range["D2:D11"].ArrayFormula = "=C2:C11*2";

// Create an array formula that multiplies values contained in the cell range B2 through D11, 
// adds the results, and displays the total sum in cell D12.
worksheet.Cells["D12"].ArrayFormula = "=SUM(B2:B11*C2:C11*D2:D11)";

// Re-dimension an array formula range:
// delete the array formula and create a new range with the same formula.
if (worksheet.Cells["C13"].HasArrayFormula) {
    string af = worksheet.Cells["C13"].ArrayFormula;
    worksheet.Cells["C13"].GetArrayFormulaRange().ArrayFormula = string.Empty;
    worksheet.Range.FromLTRB(2,1,2,10).ArrayFormula = af;
}
See Also