Cell.GetArrayFormulaRange() Method

Gets the entire range filled with an array formula, if the cell belongs to that range.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

Range GetArrayFormulaRange()

VB.NET

Function GetArrayFormulaRange As Range

Returns

Type	Description
Range	A Range of cells filled with an array formula, or null if the current cell does not belong to that range.

Remarks

Use the GetArrayFormulaRange method if your objective is to modify the array formula for a certain cell. An array formula can be modified for the entire range only, so you have to get the range via the GetArrayFormulaRange method and then use the Range.ArrayFormula property to get an array formula or to specify a new array formula.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the GetArrayFormulaRange() 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#L234

string af = worksheet.Cells["C13"].ArrayFormula;
worksheet.Cells["C13"].GetArrayFormulaRange().ArrayFormula = string.Empty;
worksheet.Range["C2:C11"].ArrayFormula = af;

wpf-spreadsheetcontrol-api-part-1-e4938/CS/SpreadsheetControl_WPF_API/SpreadsheetActions/FormulaActions.cs#L265

string af = worksheet.Cells["C13"].ArrayFormula;
worksheet.Cells["C13"].GetArrayFormulaRange().ArrayFormula = string.Empty;
worksheet.Range.FromLTRB(2,1,2,10).ArrayFormula = af;

winforms-spreadsheetcontrol-api-e4655/CS/SpreadsheetControl/SpreadsheetActions/FormulaActions.cs#L264

string af = worksheet.Cells["C13"].ArrayFormula;
worksheet.Cells["C13"].GetArrayFormulaRange().ArrayFormula = string.Empty;
worksheet.Range.FromLTRB(2,1,2,10).ArrayFormula = af;

VB.NET

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

Dim af As String = worksheet.Cells("C13").ArrayFormula
worksheet.Cells("C13").GetArrayFormulaRange().ArrayFormula = String.Empty
worksheet.Range("C2:C11").ArrayFormula = af

wpf-spreadsheetcontrol-api-part-1-e4938/VB/SpreadsheetControl_WPF_API/SpreadsheetActions/FormulaActions.vb#L263

Dim af As String = worksheet.Cells("C13").ArrayFormula
worksheet.Cells("C13").GetArrayFormulaRange().ArrayFormula = String.Empty
worksheet.Range.FromLTRB(2,1,2,10).ArrayFormula = af

winforms-spreadsheetcontrol-api-e4655/VB/SpreadsheetControl/SpreadsheetActions/FormulaActions.vb#L263

Dim af As String = worksheet.Cells("C13").ArrayFormula
worksheet.Cells("C13").GetArrayFormulaRange().ArrayFormula = String.Empty
worksheet.Range.FromLTRB(2,1,2,10).ArrayFormula = af