officefileapi-devexpress-dot-spreadsheet-faac4a30.md
Contains a legacy array formula and the range to which the formula is applied.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public interface ArrayFormula
Public Interface ArrayFormula
The following members return ArrayFormula objects:
Objects with the ArrayFormula interface are the elements of the ArrayFormulaCollection which is accessible using the Worksheet.ArrayFormulas property. The CellRange.ArrayFormula property for the range or any part of the range containing an array formula returns a string that is the ArrayFormula.Formula value.
This example creates a legacy 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;
}
' 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 Then
Dim af As String = worksheet.Cells("C13").ArrayFormula
worksheet.Cells("C13").GetArrayFormulaRange().ArrayFormula = String.Empty
worksheet.Range.FromLTRB(2,1,2,10).ArrayFormula = af
End If
See Also