AbstractFormulaChangeMonitor class

AbstractFormulaChangeMonitor class

Monitor for user to track the change of formulas during certain operations.

The AbstractFormulaChangeMonitor type exposes the following members:

Methods

MethodDescription
on_cell_formula_changed(self, sheet_index, row_index, column_index)The event that will be triggered when the formula in a cell is changed.
on_format_condition_formula_changed(self, fc)The event that will be triggered when the formula of FormatCondition is changed.

Remarks

For example, while deleting/inserting range of cells, formulas of other cells may be changed because of the shift of references. Please note, methods in the monitor may be invoked multiple times for one object which contains the formula.

See Also

AbstractCalculationMonitor class AbstractGlobalizationSettings class