# Spread COM Event Equivalents in .NET

Explore the correlation between Spread COM events and their Spread.NET member equivalents in a detailed reference guide.

## Content

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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.AutoSortedColumn.html) |
| BeforeColMove | No equivalent |
| BeforeEditMode | FpSpread.[EditModeStarting](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.EditModeStarting.html) |
| BeforeRowMove | No equivalent |
| BeforeScrollTip | No equivalent |
| BeforeUserSort | FpSpread.[AutoSortingColumn](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.AutoSortingColumn.html) |
| BlockSelected | FpSpread.[SelectionChanged](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.SelectionChanged.html) |
| ButtonClicked | FpSpread.[ButtonClicked](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ButtonClicked.html) |
| Change | FpSpread.[Change](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.Change.html) <br>SheetView.[Changed](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.Changed.html) <br>The [Change](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.Change.html) event does not occur when the formula in a cell is updated as it does in Spread COM |
| Click | FpSpread.[CellClick](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.CellClick.html) |
| ColWidthChange | FpSpread.[ColumnWidthChanged](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ColumnWidthChanged.html)<br>SheetView.[ColumnChanged](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.ColumnChanged.html) |
| ComboCloseUp | FpSpread.[ComboCloseUp](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ComboCloseUp.html) |
| ComboDropDown | FpSpread.[ComboDropDown](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ComboDropDown.html) |
| ComboSelChange | FpSpread.[ComboSelChange](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ComboSelChange.html) |
| CustomFunction | No equivalent |
| DataColConfig | FpSpread.[DataColumnConfigure](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.DataColumnConfigure.html) |
| DataFill | No equivalent |
| DataLoaded | No equivalent |
| DblClick | FpSpread.[CellDoubleClick](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.CellDoubleClick.html) |
| DragDrop | FpSpread.DragDrop (inherited from System.Windows.Forms.Control) |
| DragDropBlock | FpSpread.[DragDropBlock](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.DragDropBlock.html) |
| 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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.EditChange.html) |
| EditError | FpSpread.[EditError](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.EditError.html) <br>Enumeration: [EditError](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.EditError.html) |
| EditMode | FpSpread.[EditModeOff](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.EditModeOff.html) <br>FpSpread.[EditModeOn](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.EditModeOn.html) |
| EnterRow | FpSpread.[EnterCell](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.EnterCell.html) |
| 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 <br>OLEDragDrop <br>OLEDragOver <br>OLEGiveFeedback <br>OLESetData <br>OLEStartDrag | Inherited from .NET Control class |
| PrintAbort | FpSpread.[PrintAbort](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.PrintAbort.html) |
| PrintMsgBox | FpSpread.[PrintMessageBox](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.PrintMessageBox.html) |
| QueryAdvance | FpSpread.[Advance](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.Advance.html) |
| QueryData | No equivalent |
| RightClick | FpSpread.[CellClick](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.CellClick.html) |
| RowHeightChange | FpSpread.[RowHeightChanged](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.RowHeightChanged.html) <br>SheetView.[RowChanged](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.RowChanged.html) |
| SelChange | FpSpread.[SelectionChanging](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.SelectionChanging.html) <br>FpSpread.[SelectionChanged](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.SelectionChanged.html) |
| SheetChanged | FpSpread.[ActiveSheetChanged](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ActiveSheetChanged.html) |
| SheetChanging | FpSpread.[ActiveSheetChanging](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.ActiveSheetChanging.html) |
| TabScrolled | FpSpread.[SheetTabClick](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.SheetTabClick.html) only fires when clicking to change the active tab. |
| TabScrolling | No equivalent |
| TextTipFetch | FpSpread.[TextTipFetch](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.TextTipFetch.html) |
| TopLeftChange | FpSpread.[LeftChange](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.LeftChange.html) <br>FpSpread.[TopChange](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.TopChange.html) |
| UserFormulaEntered | FpSpread.[UserFormulaEntered](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.UserFormulaEntered.html) |
| VirtualClearData | No equivalent |
| Zoom | FpSpread.[UserZooming](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.UserZooming.html) |