Events
The following methods are defined in the SSpread class.
| Name | Description |
|---|---|
| Advance | Occurs when moving focus in the first or last cell |
| AfterColMove | Occurs after moving columns by drag and drop Added since Ver.5.0.2 |
| AfterLeaveCell | Occurs after moving the active cell Added since Ver.5.0.2 |
| AfterLeaveRow | Occurs after moving from the current row to another row Added since Ver.5.0.2 |
| AfterRowMove | Occurs after moving rows by drag and drop Added since Ver.5.0.2 |
| AfterUserSort | Occurs after data sorting is complete Added since Ver.5.0.2 |
| BeforeColMove | Occurs when trying to move a column by drag and drop |
| BeforeEditMode | Occurs just before the edit mode starts |
| BeforeRowMove | Occurs when trying to move a row by drag and drop |
| BeforeUserSort | Occurs when sorting data |
| BlockSelected | Occurs when you have finished selecting cell blocks |
| ButtonClicked | Occurs when a button is clicked in a button or check box cell |
| Change | Occurs when changing the value of the active cell |
| CircularFormula | Occurs when the formula is a circular reference |
| Clicked | Occurs when the left mouse button is pressed on a cell |
| ColWidthChange | Occurs when changing the width of a column |
| ComboCloseUp | Occurs when the drop-down list of combo box cells is closed |
| ComboDropDown | Occurs when a drop-down list of combo box cells is opened |
| ComboSelChange | Occurs when changing the selection of a combo box cell |
| DoubleClicked | Occurs when the left mouse button is double-clicked on a cell |
| DragDropBlock | Occurs when a cell block is dragged and dropped to another location |
| Dropped | Occurs when dropped by drag and drop |
| EditChange | Occurs when the value changes in a cell in input mode |
| EditError | Occurs when performing an invalid input operation |
| EditModeOff | Occurs when the input mode is turned off |
| EditModeOn | Occurs when the input mode is turned on |
| EnterRow | Occurs when moving to a new line and entering input mode |
| LButtonUp | Occurs when the left mouse button is released on a cell |
| LeaveCell | Occurs before moving the active cell |
| LeaveRow | Occurs before moving from the current row to another row |
| RButtonUp | Occurs when the right mouse button is released on a cell |
| RClicked | Occurs when the right mouse button is pressed on a cell |
| RDoubleClicked | Occurs when the right mouse button is double-clicked on a cell |
| RowHeightChange | Occurs when changing the height |
| SelChange | Occurs when selecting a cell block |
| TopLeftChange | Occurs when changing the leftmost column or top row displayed |
| UserFormulaEntered | Occurs when typing a formula in a cell |