calculate_formulas method

calculate_formulas

Calculates all formulas in the workbook and updates corresponding cells values.

def calculate_formulas(self):
    ...

Examples

Example shows how to assign a formula to the cell and to calculate a value. The value of the “B4” cell is getting set to 5.

Exceptions

ExceptionDescription
CellCircularReferenceExceptionWorkbook contains formulas with a circular reference.
CellUnsupportedDataExceptionCell data is not supported.

See Also