set_dynamic_array_formula method
Contents
[
Hide
]set_dynamic_array_formula
Sets dynamic array formula and make the formula spill into neighboring cells if possible.
Returns
the range that the formula should spill into.
def set_dynamic_array_formula(self, array_formula, options, calculate_value):
...
Parameter | Type | Description |
---|---|---|
array_formula | str | the formula expression |
options | FormulaParseOptions | options to parse formula. “Parse” option will be ignored and the formula will always be parsed immediately |
calculate_value | bool | whether calculate this dynamic array formula for those cells in the spilled range. |
set_dynamic_array_formula
Sets dynamic array formula and make the formula spill into neighboring cells if possible.
Returns
the range that the formula should spill into.
def set_dynamic_array_formula(self, array_formula, options, values, calculate_range, calculate_value):
...
Parameter | Type | Description |
---|---|---|
array_formula | str | the formula expression |
options | FormulaParseOptions | options to parse formula. “Parse” option will be ignored and the formula will always be parsed immediately |
values | list | values(calculated results) for those cells with given dynamic array formula |
calculate_range | bool | 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. |
calculate_value | bool | 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. |
set_dynamic_array_formula
Sets dynamic array formula and make the formula spill into neighboring cells if possible.
Returns
the range that the formula should spill into.
def set_dynamic_array_formula(self, array_formula, options, values, calculate_range, calculate_value, copts):
...
Parameter | Type | Description |
---|---|---|
array_formula | str | the formula expression |
options | FormulaParseOptions | options to parse formula. “Parse” option will be ignored and the formula will always be parsed immediately |
values | list | values(calculated results) for those cells with given dynamic array formula |
calculate_range | bool | 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. |
calculate_value | bool | 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 CalculationOptions.recursive property should be false. |
See Also
- module
aspose.cells
- class
Cell