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.RowChanged |
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 |