Aspose::Cells::Cell::SetDynamicArrayFormula method

Cell::SetDynamicArrayFormula(const U16String&, const FormulaParseOptions&, bool) method

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

CellArea Aspose::Cells::Cell::SetDynamicArrayFormula(const U16String &arrayFormula, const FormulaParseOptions &options, bool calculateValue)
ParameterTypeDescription
arrayFormulaconst U16String&the formula expression
optionsconst FormulaParseOptions&options to parse formula. “Parse” option will be ignored and the formula will always be parsed immediately
calculateValueboolwhether calculate this dynamic array formula for those cells in the spilled range.

ReturnValue

the range that the formula should spill into.

See Also

Cell::SetDynamicArrayFormula(const char16_t*, const FormulaParseOptions&, bool) method

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

CellArea Aspose::Cells::Cell::SetDynamicArrayFormula(const char16_t *arrayFormula, const FormulaParseOptions &options, bool calculateValue)
ParameterTypeDescription
arrayFormulaconst char16_t*the formula expression
optionsconst FormulaParseOptions&options to parse formula. “Parse” option will be ignored and the formula will always be parsed immediately
calculateValueboolwhether calculate this dynamic array formula for those cells in the spilled range.

ReturnValue

the range that the formula should spill into.

See Also