Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Version Comparison Reference / Spread COM File Member Equivalents / Spread COM Event Equivalents in .NET
In This Topic
    Spread COM Event Equivalents in .NET
    In This Topic

    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