OptionalonOptionalonCalled before delete. If any exception is thrown the exception will be returned to the client and delete will be aborted.
OptionalonCalled before load. If any exception is thrown this exception will be returned to the client and delete will fail.
OptionalonCalled before load. If any exception is thrown this exception will be returned to the client and delete will be aborted.
OptionalonCalled when a cell control is added, removed, re-anchored or reordered.
Always accompanied by the coarse onStyleChange: a control is a format.
OptionalonOptionalonOptionalonCalled when a comment is added, removed, edited, resolved, replied to or re-anchored.
Always accompanied by the coarse onStyleChange, since a cell paints its comment indicator.
OptionalonCalled when any conditional format is added, removed, re-anchored, reordered, or finishes (re)evaluating — a rule's results land asynchronously, after the calculation engine answers.
Always accompanied by the coarse onStyleChange. Listen here only when reacting to the rules themselves (an editor panel); renderers should listen to the class event instead.
OptionalonCalled when any data has changed.
The sheet.
Where the change landed and the commit that wrote it.
Values and formulas written or cleared, hyperlinks, a structural shift (insert, delete, move), a rename other sheets' formulas read through, and a calculation landing. Not formatting: that is onStyleChange. To listen for changes on data regions use ICellRange.addListener.
OptionalonCalled when any data validation is added, removed, re-anchored, or re-evaluates its results.
Always accompanied by the coarse onStyleChange. Listen here only when reacting to the validations themselves (an editor panel, the alert indicators); renderers should listen to the class event instead.
OptionalonOptionalonOptionalonOptionalonCalled when the state has been updated due to a undo/redo and a rerender is required.
OptionalonCalled when the sizes of the cells change.
One of the three coarse class events (see onStyleChange): the single subscription for "cell geometry moved".
OptionalonOptionalonCalled when any merges are added or removed.
The sheet.
Where the merges changed and the commit that changed them.
OptionalonOptionalonOptionalonOptionalonCalled when a pivot table changes: its style, its layout, or where it sits.
Always accompanied by the coarse onStyleChange.
OptionalonCalled when protected ranges are added, removed, renamed, reordered or re-anchored.
Always accompanied by the coarse onProtectionChange.
OptionalonCalled on any protection changes.
One of the three coarse class events (see onStyleChange): the single subscription for "what the user may touch changed" — the sheet lock state, its allowed actions, and the protected ranges (onProtectedRangesChange) all raise it.
OptionalonRequest that the sheet become focused.
A promise indicating if the focus was honored.
OptionalonRequest that the sheet become focused.
A promise indicating if the focus was honored.
OptionalonRequest the visible viewport ("window") bounds in absolute sheet pixels — the one placement input the model can't derive itself. Used to center a bounds-less movable (e.g. a chart via IMovableCollection.AddOptions.autoPlace); when no consumer responds (headless) the add falls back to default cursor placement.
OptionalonOptionalonOptionalonOptionalonCalled when a sparkline group is added, removed or re-anchored.
OptionalonCalled if any spills occur.
The sheet.
Where the spills changed, and the commit when a write (not a calculation) changed them.
OptionalonCalled when anything that affects how cells PAINT (other than data or layout) changes.
The sheet.
Where the formatting changed, when it is known.
One of the three coarse class events (with onLayoutChange and onProtectionChange): a single subscription for "the sheet may render differently", meant for renderers so they never have to accumulate the finer-grained events. It fires alongside each of them — direct and named style edits, table styling (onTablesChange), conditional formatting results (onConditionalFormatsChange, including their asynchronous evaluation completing), and data validation visuals (onDataValidationsChange) all raise it. Listen to a finer event only when reacting to that specific collection.
A direct style edit, and its undo and redo, announce the ranges they wrote and their commit; the collections and the caches announce the whole sheet.
OptionalonOptionalonOptionalonOptionalonCalled when the UsedRange bounds changes.
OptionalonCalled when the IWorksheetView changes.
This is not called when individual properties on the view change.
OptionalonOptionalon
Events for IWorksheet.