set_shared_formula method
Contents
[
Hide
]set_shared_formula
Sets shared formulas to a range of cells.
def set_shared_formula(self, shared_formula, row_number, column_number):
...
Parameter | Type | Description |
---|---|---|
shared_formula | str | Shared formula. |
row_number | int | Number of rows to populate the formula. |
column_number | int | Number of columns to populate the formula. |
Remarks
set_shared_formula
Sets shared formulas to a range of cells.
def set_shared_formula(self, shared_formula, row_number, column_number, options):
...
Parameter | Type | Description |
---|---|---|
shared_formula | str | Shared formula. |
row_number | int | Number of rows to populate the formula. |
column_number | int | Number of columns to populate the formula. |
options | FormulaParseOptions | Options for parsing the formula. |
set_shared_formula
Sets a formula to a range of cells.
def set_shared_formula(self, shared_formula, row_number, column_number, is_r1c1, is_local):
...
Parameter | Type | Description |
---|---|---|
shared_formula | str | Shared formula. |
row_number | int | Number of rows to populate the formula. |
column_number | int | Number of columns to populate the 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.SetSharedFormula(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_shared_formula
Sets shared formulas to a range of cells.
def set_shared_formula(self, shared_formula, row_number, column_number, options, values):
...
Parameter | Type | Description |
---|---|---|
shared_formula | str | Shared formula. |
row_number | int | Number of rows to populate the formula. |
column_number | int | Number of columns to populate the formula. |
options | FormulaParseOptions | Options for parsing the formula. |
values | list | values for those cells with given shared formula |
See Also
- module
aspose.cells
- class
Cell