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