AbstractFormulaChangeMonitor
Contents
[
Hide
]AbstractFormulaChangeMonitor class
Monitor for user to track the change of formulas during certain operations.
abstract class AbstractFormulaChangeMonitor;
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.
Methods
| Method | Description |
|---|---|
| abstract onCellFormulaChanged(number, number, number) | The event that will be triggered when the formula in a cell is changed. |
| abstract onFormatConditionFormulaChanged(FormatCondition) | The event that will be triggered when the formula of FormatCondition is changed. |
onCellFormulaChanged(number, number, number)
The event that will be triggered when the formula in a cell is changed.
abstract onCellFormulaChanged(sheetIndex: number, rowIndex: number, columnIndex: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| sheetIndex | number | The sheet index of the changed cell |
| rowIndex | number | The row index of the changed cell |
| columnIndex | number | The column index of the changed cell |
onFormatConditionFormulaChanged(FormatCondition)
The event that will be triggered when the formula of FormatCondition is changed.
abstract onFormatConditionFormulaChanged(fc: FormatCondition) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| fc | FormatCondition | The FormatCondition object whose formula is changed |