type | Description |
---|---|
ActiveSheetChanged | Occurs when the user has changed the active sheet. |
ActiveSheetChanging | Occurs when the user is changing the active sheet. |
ButtonClicked | Occurs when the user clicks a button, check box, or hyperlink in a cell. |
CellChanged | Occurs when a change is made to a cell in this sheet that may require the cell to be repainted. |
CellClick | Occurs when the user presses down the left mouse button in a cell. |
CellDoubleClick | Occurs when the user presses down the left mouse button twice (double-clicks) in a cell. |
ClipboardChanged | Occurs when a Clipboard change occurs that affects Spread.Sheets. |
ClipboardChanging | Occurs when the Clipboard is changing due to a Spread.Sheets action. |
ClipboardPasted | Occurs when the user pastes from the Clipboard. |
ClipboardPasting | Occurs when the user is pasting from the Clipboard. |
ColumnChanged | Occurs when a change is made to a column or range of columns in this sheet that may require the column or range of columns to be repainted. |
ColumnWidthChanged | Occurs when the column width has changed. |
ColumnWidthChanging | Occurs when the column width is changing. |
CommentChanged | Occurs when any comment has changed. |
CommentRemoved | Occurs when the user has removed the comment. |
CommentRemoving | Occurs when the user is removing any comment. |
DragDropBlock | Occurs when the user is dragging and dropping a range of cells. |
DragDropBlockCompleted | Occurs when the user completes dragging and dropping a range of cells. |
DragFillBlock | Occurs when the user is dragging to fill a range of cells. |
DragFillBlockCompleted | Occurs when the user completes dragging to fill a range of cells. |
DragMerged | Occurs after user drag merge cells. |
DragMerging | Occurs before user drag merge cells. |
EditChange | Occurs when a cell is in edit mode and the text is changed. |
EditEnded | Occurs when a cell leaves edit mode. |
EditEnding | Occurs when a cell is leaving edit mode. |
EditorStatusChanged | Occurs when the editor's status has changed. |
EditStarting | Occurs when a cell is entering edit mode. |
EnterCell | Occurs when the focus enters a cell. |
FloatingObjectChanged | Occurs when any floating object has changed. |
FloatingObjectLoaded | Occurs when the custom floating object content is loaded. |
FloatingObjectRemoved | Occurs when the user has removed the floating object. |
FloatingObjectRemoving | Occurs when the user is removing any floating object. |
FloatingObjectSelectionChanged | Occurs when the selections of the floating object have changed. |
InvalidOperation | Occurs when an invalid operation is performed. |
LeaveCell | Occurs when the focus leaves a cell. |
LeftColumnChanged | Occurs when the left column changes. |
PictureChanged | Occurs when any picture has changed. |
PictureSelectionChanged | Occurs when the selections of the picture have changed. |
RangeChanged | Occurs when the cell range has changed. |
RangeFiltered | Occurs when a column has just been automatically filtered. |
RangeFiltering | Occurs when a column is about to be automatically filtered. |
RangeGroupStateChanged | Occurs when the user has changed the outline state (range group) for rows or columns. |
RangeGroupStateChanging | Occurs before the user changes the outline state (range group) for rows or columns. |
RangeSorted | Occurs when a column has just been automatically sorted. |
RangeSorting | Occurs when a column is about to be automatically sorted. |
RowChanged | Occurs when a change is made to a row or range of rows in this sheet that may require the row or range of rows to be repainted. |
RowHeightChanged | Occurs when the row height has changed. |
RowHeightChanging | Occurs when the row height is changing. |
SelectionChanged | Occurs when the selection of cells on the sheet has changed. |
SelectionChanging | Occurs when the selection of cells on the sheet is changing. |
SheetMoved | Occurs after the user drags and moves the sheet. |
SheetMoving | Occurs before the user drags and moves the sheet. |
SheetNameChanged | Occurs when the user has changed the sheet name. |
SheetNameChanging | Occurs when the user is changing the sheet name. |
SheetTabClick | Occurs when the user clicks the sheet tab. |
SheetTabDoubleClick | Occurs when the user double-clicks the sheet tab. |
SlicerChanged | Occurs when any slicer has changed. |
SparklineChanged | Occurs when the sparkline has changed. |
TableFiltered | Occurs when a table column has just been automatically filtered. |
TableFiltering | Occurs when a table column is about to be automatically filtered. |
TopRowChanged | Occurs when the top row changes. |
TouchToolStripOpening | Occurs before the touch toolbar pops up. |
UserFormulaEntered | Occurs when the user types a formula. |
UserZooming | Occurs when the user zooms. |
ValidationError | Occurs when the applied cell value is invalid. |
ValueChanged | Occurs when the value in the subeditor changes. |