| Event ID | Event Name | Event Description |
|---|
| 1 | Advance | Occurs when the user presses the Tab key or down arrow in the last cell, or Shift+Tab key or up arrow in the first cell. |
| 2 | BlockSelected | Occurs when the user completes the selection of a block of cells. |
| 3 | BtnClicked | Occurs when the user clicks a button cell or check box cell. |
| 4 | Change | Occurs when the user modifies the contents of a cell and then leaves the cell. |
| 5 | Click | Occurs when the user clicks a cell using the left mouse button. |
| 6 | ColWidthChange | Occurs when the user changes the column width using the mouse. |
| 7 | CustomFunction | Occurs when a custom function is evaluated in a cell’s formula. |
| 9 | DataColConfig | Occurs for each column in the spreadsheet as the spreadsheet is bound to a database. |
| 10 | DataFill | Occurs for each cell in the fpSpread control before it receives data from the database and before it writes data to the database, if the DataFillEvent property is set to True for the cell. |
| 11 | DblClick | Occurs when the user double-clicks the left mouse button while the pointer is in a cell. |
| 12 | DragDropBlock | Occurs when the user drags and drops a block of cells to a new location. |
| 13 | DrawItem | Occurs when the fpSpread control displays an owner-drawn cell. |
| 14 | EditError | Occurs when the user performs an invalid input operation. |
| 15 | EditMode | Occurs when the user enters or leaves edit mode in a cell. |
| 16 | EnterRow | Occurs when the operation mode is set to row mode and the focus moves to a new row. |
| 17 | LeaveCell | Occurs when the user moves the active cell from one cell to another, or moves the focus outside of the spreadsheet. |
| 18 | LeaveRow | Occurs when the operation mode is set to row mode and the focus moves to a new row. |
| 19 | PrintAbort | Occurs repeatedly when the spreadsheet is printing. |
| 20 | QueryAdvance | Occurs when the user moves the focus to the next or previous control on the form. |
| 21 | QueryData | Occurs when virtual mode is on and the fpSpread control requests additional data. |
| 22 | RightClick | Occurs when the user clicks a cell with the right mouse button. |
| 23 | RowHeightChange | Occurs when the user changes the height of a row. |
| 24 | SelChange | Occurs while the user is selecting a block of cells. |
| 25 | TopLeftChange | Occurs when the displayed left column or top row changes. |
| 26 | UserFormulaEntered | Occurs when the user types a formula. |
| 27 | VirtualClearData | Occurs when the spreadsheet is in virtual mode and data in the virtual buffer needs to be discarded. |
| 28 | PrintMsgBox | Occurs before the provided print abort dialog box is displayed and after the print job is complete. |
| 29 | ComboCloseUp | Occurs when the drop-down list portion of a combo box cell closes. |
| 30 | ComboDropDown | Occurs when the drop-down list portion of the combo box cell drops down. |
| 31 | ComboSelChange | Occurs when the user changes the selection in a combo box cell. |
| 32 | TextTipFetch | Occurs when the control displays a text tip. |
| 33 | EditChange | Occurs when a cell is in edit mode and the text changes in the cell. |
| | | |
34 | OLECompleDrag | Occurs at the OLE drag/drop source control after a manual or automatic drag/drop has been completed or canceled. |
| 35 | OLEDragDrop | Occurs when data is dropped onto the control via an OLE drag/drop operation, and OLEDropMode is set to manual. |
| 36 | OLEDragOver | Occurs when the mouse is moved over the control during an OLE drag/drop operation, if its OLEDropMode property is set to manual. |
| 37 | OLEGiveFeedback | Occurs at the source control of an OLE drag/drop operation when the mouse cursor needs to be changed. |
| 38 | OLESetData | Occurs at the OLE drag/drop source control when the drop target requests data that was not provided to the DataObject during the OLEDragStart event. |
| 39 | OLEStartDrag | Occurs when an OLE drag/drop operation is initiated either manually or automatically. |
| | | |
40 | BeforeUserSort | Occurs before an AutoSort occurs when a sortable column header is clicked. |
| 41 | AfterUserSort | Occurs after an AutoSort occurs when a sortable column header is clicked. |
| | | |
45 | OLECompleteDrag | Occurs at the OLE drag/drop source control after a manual or automatic drag/drop has been completed or canceled. |
| 46 | OLEDragDrop | Occurs when data is dropped onto the control via an OLE drag/drop operation, and OLEDropMode is set to manual. |
| 47 | OLEDragOver | Occurs when the mouse is moved over the control during an OLE drag/drop operation, if its OLEDropMode property is set to manual. |
| 48 | OLEGiveFeedback | Occurs at the source control of an OLE drag/drop operation when the mouse cursor needs to be changed. |
| 49 | OLESetData | Occurs at the OLE drag/drop source control when the drop target requests data that was not provided to the DataObject during the OLEDragStart event. |
| 50 | OLEStartDrag | Occurs when an OLE drag/drop operation is initiated either manually or automatically. |
| | | |
101 | ScriptCustomFunction | Occurs when a custom function is evaluated in a cell’s formula. |
| 102 | ScriptDataFill | Occurs for each cell in the fpSpread control before it receives data from the database and before it writes data to the database, if the DataFillEvent property is set to True for the cell. |
| 103 | ScriptDragDropBlock | Occurs when the user drags and drops a block of cells to a new location. |
| 104 | ScriptLeaveCell | Occurs when the user moves the active cell from one cell to another, or moves the focus outside of the spreadsheet. |
| 105 | ScriptLeaveRow | Occurs when the operation mode is set to row mode and the focus moves to a new row. |
| 106 | ScriptPrintAbort | Occurs repeatedly when the spreadsheet is printing. |
| 107 | ScriptQueryAdvance | Occurs when the user moves the focus to the next or prev
|