CellSetArrayFormula Method (String, Int32, Int32, Boolean, Boolean)
Sets an array formula to a range of cells.

Namespace: Aspose.Cells
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: 19.11.0.0 (19.11)
Syntax
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
See Also