Spread COM Event Equivalents in .NET
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 |