CellSetArrayFormula Method (String, Int32, Int32, Boolean, Boolean)

Note: This API is now obsolete.

Sets an array formula to a range of cells.

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 20.4.0.0 (20.4)
Syntax
[ObsoleteAttribute("Use FormulaParseOptions for more options instead.")]
public void SetArrayFormula(
	string arrayFormula,
	int rowNumber,
	int columnNumber,
	bool isR1C1,
	bool isLocal
)

Parameters

arrayFormula
Type: SystemString
Array formula.
rowNumber
Type: SystemInt32
Number of rows to populate result of the array formula.
columnNumber
Type: SystemInt32
Number of columns to populate result of the array formula.
isR1C1
Type: SystemBoolean
whether the formula is R1C1 formula
isLocal
Type: SystemBoolean
whether the formula is locale formatted
Remarks
NOTE: This class is now obsolete. Instead, please use Cell.SetArrayFormula(string,int,int,FormulaParseOptions). This property will be removed 12 months later since December 2019. Aspose apologizes for any inconvenience you may have experienced.
See Also