Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / SheetDragMoving Event

In This Topic
    SheetDragMoving Event
    In This Topic
    Occurs when the user drag-move the sheet name tab to move sheet.
    Public Event SheetDragMoving As SheetDragMovingEventHandler
    Dim instance As FpSpread
    Dim handler As SheetDragMovingEventHandler
    AddHandler instance.SheetDragMoving, handler
    public event SheetDragMovingEventHandler SheetDragMoving
    Event Data

    The event handler receives an argument of type SheetDragMovingEventArgs containing data related to this event. The following SheetDragMovingEventArgs properties provide information specific to this event.

    Gets or sets whether to cancel the sheet drag and move action.  
    Gets or sets whether to allow the sheet to be moved to the ToSheetIndex location.  
    Gets the index of the sheet that is being moved.  
    Gets the index of the new position where the sheet is being moved.  

    Select a sheet tab on the tab strip, drag the sheet tab to another tab, then release the mouse to move the sheet from the old index to the new index. The SheetDragMoving event occurs when the user starts dragging the sheet tab name. The SheetDragMoved event occurs right after the user moves the sheet. You can prevent specific sheets from being moved by setting the Cancel property to true.

    This event only occurs when the user uses the mouse to move a sheet.

    This example prevents a sheet from being moved to sheet 3.
    private void fpSpread1_SheetDragMoving(object sender, FarPoint.Win.Spread.SheetDragMovingEventArgs e)
                if (e.ToSheetIndex == 3)
                    e.Cancel = true;
                    //or e.Restrict = true;
            private void fpSpread1_SheetDragMoved(object sender, FarPoint.Win.Spread.SheetDragMovedEventArgs e)
                listBox1.Items.Add("previous " + e.OldSheetIndex);
                listBox1.Items.Add("new " + e.NewSheetIndex);
            private void Form1_Load(object sender, EventArgs e)
                fpSpread1.Sheets.Count = 5;
                fpSpread1.AllowSheetMove = true;
    Private Sub fpSpread1_SheetDragMoved(sender As Object, e As FarPoint.Win.Spread.SheetDragMovedEventArgs) Handles fpSpread1.SheetDragMoved
            ListBox1.Items.Add("previous " & e.OldSheetIndex)
            ListBox1.Items.Add("new " & e.NewSheetIndex)
        End Sub
        Private Sub fpSpread1_SheetDragMoving(sender As Object, e As FarPoint.Win.Spread.SheetDragMovingEventArgs) Handles fpSpread1.SheetDragMoving
            If e.ToSheetIndex = 3 Then
                e.Cancel = True
               'or e.Restrict = True
            End If
        End Sub
        Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
            fpSpread1.Sheets.Count = 5
            fpSpread1.AllowSheetMove = True
        End Sub
    See Also