Spread Windows Forms 12.0 Product Documentation
Spread COM Event Equivalents in .NET
Spread Windows Forms 12.0 Product Documentation > Version Comparison Reference > Spread COM File Member Equivalents > 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