| Advance |
Occurs when the user performs one
of the following actions:
- Presses the Tab key when the focus is in the
last cell
- Presses Shift+Tab when the focus is in the first cell
-
Presses the down arrow key when the focus is in the last row
- Presses the
up arrow key when the focus is in the first row |
| AfterUserSort |
Occurs after the user clicks a
column header and the column is sorted or if the ColUserSortIndicator property
is set to either 1(Ascending) or 2 (Descending) for a column and the
UserColAction property is set to 1 (Sort) or 2 (SortNoIndicator). |
| BeforeUserSort,
ScriptBeforeUserSort |
Occurs when the user clicks a
column header and the UserColAction property is set to either 1 (Sort) or 2
(Sort No Indicator) and the ColUserSortIndicator property is not set to 3
(Disabled). |
| BlockSelected |
Occurs when the user completes the
selection of a block of cells. |
| ButtonClicked |
Occurs when the user clicks a
button cell or check box cell. |
| Change |
Occurs when the user modifies the
contents of a cell. |
| Click |
Occurs when the user clicks a cell
using the left mouse button. |
| ColWidthChange |
Occurs when the user changes the
column width using the mouse. |
| ComboCloseUp |
Occurs when the drop-down list
portion of a combo box cell closes. |
| ComboDropDown |
Occurs when the drop-down list
portion of the combo box cell drops down. |
| ComboSelChange |
Occurs when the user changes the
selection in a combo box cell. |
| CustomFunction,
ScriptCustomFunction |
Occurs when a custom function is
evaluated in a cell’s formula. |
| DataColConfig |
Occurs for each column in the
spreadsheet as the spreadsheet is bound to a database.You can evaluate the cell
types set by the fpSpread control for the bound data and change them as needed
within the event procedure. |
| DataFill, 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. |
| DblClick |
Occurs when the user double-clicks
the left mouse button while the pointer is in a cell. |
| DragDrop |
Refer to the Visual Basic
documentation for more information about this standard event. |
| DragDropBlock,
ScriptDragDropBlock |
Occurs when the user drags and
drops a block of cells to a new location. |
| DragOver |
Refer to the Visual Basic
documentation for more information about this standard event. |
| DrawItem |
Occurs when the fpSpread control
displays an owner-drawn cell. |
| EditChange |
Occurs when a cell is in edit mode
and the text changes in the cell. When the user types data in a cell or
double-clicks a cell in the spreadsheet, the cell enters edit mode. |
| EditError |
Occurs when the user performs an
invalid input operation. |
| EditMode |
Occurs when the user enters or
leaves edit mode in a cell. |
| EnterRow |
Occurs when the operation mode is
set to row mode and the user enters edit mode in a new cell in a new row. |
| GotFocus |
Refer to the Visual Basic
documentation for more information about this standard event. |
| KeyDown |
Refer to the Visual Basic
documentation for more information about this standard event. |
| KeyPress |
Refer to the Visual Basic
documentation for more information about this standard event. |
| KeyUp |
Refer to the Visual Basic
documentation for more information about this standard event. |
| LeaveCell, ScriptLeaveCell
|
Occurs when the user moves the
active cell from one cell to another, or moves the focus outside of the
spreadsheet. |
| LeaveRow, ScriptLeaveRow
|
Occurs when the operation mode is
set to row mode and the focus moves to a new row. |
| LostFocus |
Refer to the Visual Basic
documentation for more information about this standard event. |
| MouseDown |
Refer to the Visual Basic
documentation for more information about this standard event. |
| MouseMove |
Refer to the Visual Basic
documentation for more information about this standard event. |
| MouseUp |
Refer to the Visual Basic
documentation for more information about this standard event. |
| OLECompleteDrag,
ScriptOLECompleteDrag |
Occurs at the source control after
an OLE drag-drop operation has been completed or canceled. |
| OLEDragDrop, ScriptOLEDragDrop
|
Occurs when data is dropped onto
the control. |
| OLEDragOver, ScriptOLEDragOver
|
Occurs when the mouse is moved over
the target control during an OLE drag-drop operation. |
| OLEGiveFeedback,
ScriptOLEGiveFeedback |
Provides visual feedback through
the pointer, by the source control for a drag-drop operation. |
| OLESetData |
Occurs at the drag-drop source
control when the drop target requests data that was not provided to the
fpDataObject. |
| OLEStartDrag, Script
OLEStartDrag |
Occurs when an OLE drag-drop
operation is initiated either manually or automatically. |
| PrintAbort, ScriptPrintAbort
|
Occurs repeatedly when the
spreadsheet is printing.When the user clicks the Cancel button in a print abort
dialog box, the fpSpread control passes the Abort parameter as True to inform
the application that printing has stopped. |
| PrintMsgBox, ScriptPrintMsgBox
|
Occurs before the provided print
abort dialog box is displayed and after the print job is complete. Use this
event to provide a custom print abort dialog box for the user by overriding the
provided print abort dialog box. |
| QueryAdvance,
ScriptQueryAdvance |
Occurs when the user moves the
focus to the next or previous control on the form. This event occurs only in
Visual Basic version 2.0 or later. |
| QueryData, ScriptQueryData
|
Occurs when virtual mode is on and
the fpSpread control requests additional data. |
| RightClick |
Occurs when the user clicks a cell
with the right mouse button. |
| RowHeightChange |
Occurs when the user changes the
height of a row. |
| SelChange |
Occurs while the user is selecting
a block of cells. |
| TextTipFetch,
ScriptTextTipFetch |
Occurs whenever the pointer is over
a cell or header cell and the TextTip property is set to a value other than 0
(None). Use this event to display text tips, to respond to the display of text
tips, to configure text tips, or to not display a text tip for a cell or
header. Set the ShowTip parameter to True or 1 to display text tips for the
spreadsheet. |
| TopLeftChange |
Occurs when the displayed left
column or top row changes. |
| UserFormulaEntered |
Occurs when the user types a
formula. |
| Validate |
Refer to the Visual Basic
documentation for more information about this standard event. |
| VirtualClearData |
Occurs when the spreadsheet is in
virtual mode and data in the virtual buffer needs to be discarded. The
VirtualClearData event occurs before the data in the virtual buffer is cleared,
giving the application an opportunity to process the data before it is
discarded. |