set_array_formula method
Contents
[
Hide
]set_array_formula
Sets an array formula(legacy array formula entered via CTRL+SHIFT+ENTER in ms excel) to a range of cells.
def set_array_formula(self, array_formula, row_number, column_number):
...
| Parameter | Type | Description |
|---|---|---|
| array_formula | str | Array formula. |
| row_number | int | Number of rows to populate result of the array formula. |
| column_number | int | Number of columns to populate result of the array formula. |
set_array_formula
Sets an array formula to a range of cells.
def set_array_formula(self, array_formula, row_number, column_number, options):
...
| Parameter | Type | Description |
|---|---|---|
| array_formula | str | Array formula. |
| row_number | int | Number of rows to populate result of the array formula. |
| column_number | int | Number of columns to populate result of the array formula. |
| options | FormulaParseOptions | Options for parsing the formula. |
set_array_formula
Sets an array formula to a range of cells.
def set_array_formula(self, array_formula, row_number, column_number, is_r1c1, is_local):
...
| Parameter | Type | Description |
|---|---|---|
| array_formula | str | Array formula. |
| row_number | int | Number of rows to populate result of the array formula. |
| column_number | int | Number of columns to populate result of the array formula. |
| is_r1c1 | bool | whether the formula is R1C1 formula |
| is_local | bool | 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.
set_array_formula
Sets an array formula to a range of cells.
def set_array_formula(self, array_formula, row_number, column_number, options, values):
...
| Parameter | Type | Description |
|---|---|---|
| array_formula | str | Array formula. |
| row_number | int | Number of rows to populate result of the array formula. |
| column_number | int | Number of columns to populate result of the array formula. |
| options | FormulaParseOptions | Options for parsing the formula. |
| values | list | values for those cells with given array formula |
See Also
- module
aspose.cells - class
Cell
