Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetDragMovingEventArgs Class / Cancel Property

In This Topic
    Cancel Property (SheetDragMovingEventArgs)
    In This Topic
    Gets or sets whether to cancel the sheet drag and move action.
    Public Property Cancel As Boolean
    Dim instance As SheetDragMovingEventArgs
    Dim value As Boolean
    instance.Cancel = value
    value = instance.Cancel
    public bool Cancel {get; set;}
    This example uses the Cancel property.
    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