OptionalonOptionalonCalled before delete. If any exception is thrown the exception will be returned to the client and delete will be aborted.
OptionalonOptionalonCalled before load. If any exception is thrown this exception will be returned to the client and delete will be aborted.
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.
This is a course event that indicates that data has changed. 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".
OptionalonOptionalonOptionalonOptionalonOptionalonOptionalonCalled 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.
OptionalonOptionalonOptionalonOptionalonOptionalonCalled when anything that affects how cells PAINT (other than data or layout) changes.
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.
OptionalonOptionalonOptionalonOptionalonCalled when the UsedRange bounds changes.
OptionalonCalled when the ISheetView changes.
This is not called when individual properties on the view change.
OptionalonOptionalon
Events for ISheet.