SetDynamicArrayFormula

SetDynamicArrayFormula(string, FormulaParseOptions, bool)

Sets dynamic array formula and make the formula spill into neighboring cells if possible.

public CellArea SetDynamicArrayFormula(string arrayFormula, FormulaParseOptions options, 
    bool calculateValue)
Parameter Type Description
arrayFormula String the formula expression
options FormulaParseOptions options to parse formula. “Parse” option will be ignored and the formula will always be parsed immediately
calculateValue Boolean whether calculate this dynamic array formula for those cells in the spilled range.

Return Value

the range that the formula should spill into.

See Also


SetDynamicArrayFormula(string, FormulaParseOptions, object[][], bool, bool)

Sets dynamic array formula and make the formula spill into neighboring cells if possible.

public CellArea SetDynamicArrayFormula(string arrayFormula, FormulaParseOptions options, 
    object[][] values, bool calculateRange, bool calculateValue)
Parameter Type Description
arrayFormula String the formula expression
options FormulaParseOptions options to parse formula. “Parse” option will be ignored and the formula will always be parsed immediately
values Object[][] values for those cells with given dynamic array formula
calculateRange Boolean Whether calculate the spilled range for this dynamic array formula. If the “values” parameter is not null and this flag is false, then the spilled range’s height will be values.Length and width will be values[0].Length.
calculateValue Boolean whether calculate this dynamic array formula for those cells in the spilled range when “values” is null or corresponding item in “values” for one cell is null.

Return Value

the range that the formula should spill into.

See Also


SetDynamicArrayFormula(string, FormulaParseOptions, object[][], bool, bool, CalculationOptions)

Sets dynamic array formula and make the formula spill into neighboring cells if possible.

public CellArea SetDynamicArrayFormula(string arrayFormula, FormulaParseOptions options, 
    object[][] values, bool calculateRange, bool calculateValue, CalculationOptions copts)
Parameter Type Description
arrayFormula String the formula expression
options FormulaParseOptions options to parse formula. “Parse” option will be ignored and the formula will always be parsed immediately
values Object[][] values for those cells with given dynamic array formula
calculateRange Boolean Whether calculate the spilled range for this dynamic array formula. If the “values” parameter is not null and this flag is false, then the spilled range’s height will be values.Length and width will be values[0].Length.
calculateValue Boolean whether calculate this dynamic array formula for those cells in the spilled range when “values” is null or corresponding item in “values” for one cell is null.
copts CalculationOptions The options for calculating formula. Commonly, for performance consideration, the Recursive property should be false.

Return Value

the range that the formula should spill into.

See Also