Events

onAfterConditionSet fires after a new condition for cells was set
onAfterLoad fires after data loading is complete
onAfterRangeSet fires after a range of cells is set
onAfterSelect fires after a cell has been selected
onAfterSheetShow fires after a sheet has opened
onAfterSpan fires after cells are merged
onAfterSplit fires after a span was removed
onBeforeCommentShow fires before a comment for a cell is shown
onBeforeConditionSet fires before a new condition for cells has been set
onBeforeFormatChange fires before cell format is changed
onBeforeLoad fires immediately before data loading has started
onBeforeSheetMenu fires before the bottom bar menu is shown
onBeforeSheetShow fires before a sheet is opened
onBeforeSpan fires before cells are merged
onBeforeSplit fires before merged cells are split
onBeforeStyleChange fires before applying a new style for a cell
onBeforeValueChange fires before the value of a cell is changed
onBindRequest fires when the component is ready to receive data from the master component
onCellChange fires when a cell is changed
onChange fires when any change occurs
onColumnOperation fires after the user performed an operation on columns
onCommand fires when selecting an option in a context menu, opening an external UI or dialog, updating a toolbar, or performing some action on a table
onCommentHide fires after a comment is hidden
onComponentInit fires when spreadsheet is initialized
onContextMenuConfig fires every time before opening the context menu
onDataParse fires when data parsing is started
onDataSerialize fires when serialization of data is started
onDestruct occurs when component destroyed
onFormatChange fires when cell format is changed
onLoadError fires when an error occurs during data loading (invalid server side response)
onMathRefresh fires when recalculation of formulas in the sheet is complete
onReset fires when the settings of SpreadSheet are reset to the initial state
onRowOperation fires after the user performed an operation on rows
onSheetAdd fires when a new sheet is added
onSheetRemove fires when a sheet is removed
onSheetRename fires when a sheet is renamed
onStyleChange fires after applying a new style for a cell
onStyleSet fires when a new style is set for a cell
onUIEditStart fires when editing form is opened
onUIEditStop fires when editing form is closed
onUndo fires when undo/redo operations are performed
onViewInit fires before an inner view of spreadsheet is initialized
onViewShow fires when any hidden view is shown
onZoom fires after the user has zoomed a sheet
Back to top