convert_formula_reference_style method

convert_formula_reference_style

Converts the formula reference style.

Returns

The converted formula.

def convert_formula_reference_style(self, formula, to_r1c1, base_cell_row, base_cell_column):
    ...
ParameterTypeDescription
formulastrThe formula to be converted.
to_r1c1boolWhich reference style to convert the formula to.
If the original formula is of A1 reference style,
then this value should be true so the formula will be converted from A1 to R1C1 reference style;
If the original formula is of R1C1 reference style,
then this value should be false so the formula will be converted from R1C1 to A1 reference style;
base_cell_rowintThe row index of the base cell.
base_cell_columnintThe column index of the base cell.

See Also