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


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