The following table lists the Spread COM events and their Spread.NET member equivalents. It also lists the Spread.NET enumerations that go with these events.
| Spread COM Event | Spread.NET Member |
|---|---|
|
Advance |
No equivalent |
|
AfterUserSort |
FpSpread.AutoSortedColumn |
|
BeforeColMove |
No equivalent |
|
BeforeEditMode |
FpSpread.EditModeStarting |
|
BeforeRowMove |
No equivalent |
|
BeforeScrollTip |
No equivalent |
|
BeforeUserSort |
FpSpread.AutoSortingColumn |
|
BlockSelected |
FpSpread.SelectionChanged |
|
ButtonClicked |
FpSpread.ButtonClicked |
|
Change |
FpSpread.Change SheetView.Changed The Change event does not occur when the formula in a cell is updated as it does in Spread COM |
|
Click |
FpSpread.CellClick |
|
ColWidthChange |
FpSpread.ColumnWidthChanged SheetView.ColumnChanged |
|
ComboCloseUp |
FpSpread.ComboCloseUp |
|
ComboDropDown |
FpSpread.ComboDropDown |
|
ComboSelChange |
FpSpread.ComboSelChange |
|
CustomFunction |
No equivalent |
|
DataColConfig |
FpSpread.DataColumnConfigure |
|
DataFill |
No equivalent |
|
DataLoaded |
No equivalent |
|
DblClick |
FpSpread.CellDoubleClick |
|
DragDrop |
FpSpread.DragDrop (inherited from System.Windows.Forms.Control) |
|
DragDropBlock |
FpSpread.DragDropBlock |
|
DragOver |
FpSpread.DragOver (inherited from System.Windows.Forms.Control) |
|
DrawItem |
No equivalent; owner-drawn cells are no longer supported; create custom cell types instead |
|
EditChange |
FpSpread.EditChange |
|
EditError |
FpSpread.EditError Enumeration: EditError |
|
EditMode |
FpSpread.EditModeOff FpSpread.EditModeOn |
|
EnterRow |
FpSpread.EnterCell |
|
GotFocus |
FpSpread.GotFocus (inherited from System.Windows.Forms.Control) |
|
KeyDown |
FpSpread.KeyDown (inherited from System.Windows.Forms.Control) |
|
KeyPress |
FpSpread.KeyPress (inherited from System.Windows.Forms.Control) |
|
KeyUp |
FpSpread.KeyUp (inherited from System.Windows.Forms.Control) |
|
LeaveCell |
FpSpread.LeaveCell (inherited from System.Windows.Forms.Control) |
|
LeaveRow |
FpSpread.LeaveCell (inherited from System.Windows.Forms.Control) |
|
LostFocus |
FpSpread.LostFocus (inherited from System.Windows.Forms.Control) |
|
MouseDown |
FpSpread.MouseDown (inherited from System.Windows.Forms.Control) |
|
MouseMove |
FpSpread.MouseMove (inherited from System.Windows.Forms.Control) |
|
MouseUp |
FpSpread.MouseUp (inherited from System.Windows.Forms.Control) |
|
OLECompleteDrag OLEDragDrop OLEDragOver OLEGiveFeedback OLESetData OLEStartDrag |
Inherited from .NET Control class |
|
PrintAbort |
FpSpread.PrintAbort |
|
PrintMsgBox |
FpSpread.PrintMessageBox |
|
QueryAdvance |
FpSpread.Advance |
|
QueryData |
No equivalent |
|
RightClick |
FpSpread.CellClick |
|
RowHeightChange |
FpSpread.RowHeightChanged SheetView.RowChange |
|
SelChange |
FpSpread.SelectionChanging FpSpread.SelectionChanged |
|
SheetChanged |
FpSpread.ActiveSheetChanged |
|
SheetChanging |
FpSpread.ActiveSheetChanging |
|
TabScrolled |
FpSpread.SheetTabClick only fires when clicking to change the active tab. |
|
TabScrolling |
No equivalent |
|
TextTipFetch |
FpSpread.TextTipFetch |
|
TopLeftChange |
FpSpread.LeftChange FpSpread.TopChange |
|
UserFormulaEntered |
FpSpread.UserFormulaEntered |
|
VirtualClearData |
No equivalent |
|
Zoom |
FpSpread.UserZooming |