SetArrayFormula

SetArrayFormula(string, int, int, bool, bool)

Sets an array formula to a range of cells.

[Obsolete("Use FormulaParseOptions for more options instead.")]
[EditorBrowsable(EditorBrowsableState.Never)]
public void SetArrayFormula(string arrayFormula, int rowNumber, int columnNumber, bool isR1C1, 
    bool isLocal)
Parameter Type Description
arrayFormula String Array formula.
rowNumber Int32 Number of rows to populate result of the array formula.
columnNumber Int32 Number of columns to populate result of the array formula.
isR1C1 Boolean whether the formula is R1C1 formula
isLocal Boolean 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


SetArrayFormula(string, int, int)

Sets an array formula(legacy array formula entered via CTRL+SHIFT+ENTER in ms excel) to a range of cells.

public void SetArrayFormula(string arrayFormula, int rowNumber, int columnNumber)
Parameter Type Description
arrayFormula String Array formula.
rowNumber Int32 Number of rows to populate result of the array formula.
columnNumber Int32 Number of columns to populate result of the array formula.

See Also


SetArrayFormula(string, int, int, FormulaParseOptions)

Sets an array formula to a range of cells.

public void SetArrayFormula(string arrayFormula, int rowNumber, int columnNumber, 
    FormulaParseOptions options)
Parameter Type Description
arrayFormula String Array formula.
rowNumber Int32 Number of rows to populate result of the array formula.
columnNumber Int32 Number of columns to populate result of the array formula.
options FormulaParseOptions Options for parsing the formula.

See Also


SetArrayFormula(string, int, int, FormulaParseOptions, object[][])

Sets an array formula to a range of cells.

public void SetArrayFormula(string arrayFormula, int rowNumber, int columnNumber, 
    FormulaParseOptions options, object[][] values)
Parameter Type Description
arrayFormula String Array formula.
rowNumber Int32 Number of rows to populate result of the array formula.
columnNumber Int32 Number of columns to populate result of the array formula.
options FormulaParseOptions Options for parsing the formula.
values Object[][] values for those cells with given array formula

See Also