Spread WPF 14
GrapeCity.Windows.SpreadSheet.UI Namespace / GcSpreadSheet Class / DragDropBlockCompleted Event
Example


In This Topic
    DragDropBlockCompleted Event (GcSpreadSheet)
    In This Topic
    Occurs at the completion of the user dragging and dropping a range of cells.
    Syntax
    'Declaration
     
    Public Event DragDropBlockCompleted As EventHandler(Of DragDropBlockCompletedEventArgs)
    'Usage
     
    Dim instance As GcSpreadSheet
    Dim handler As EventHandler(Of DragDropBlockCompletedEventArgs)
     
    AddHandler instance.DragDropBlockCompleted, handler
    public event EventHandler<DragDropBlockCompletedEventArgs> DragDropBlockCompleted
    Event Data

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

    PropertyDescription
    Gets the column count of the cell range being dragged.  
    Gets whether the source range is copied.  
    Gets the CopyOption value for the drag and drop operation.  
    Gets the column index of the top left cell of the source range (range being dragged).  
    Gets the row index of the top left cell of the source range (range being dragged).  
    Gets whether the source range is inserted.  
    Gets the row count of the cell range being dragged.  
    Gets the column index of the bottom right cell of the destination range (where selection is dropped).  
    Gets the row index of the top left cell of the destination range (where selection is dropped).  
    Example
    This example uses the DragDropBlockCompleted event.
    gcSpreadSheet1.DragDropBlock += new EventHandler<DragDropBlockEventArgs>(gcSpread1_DragDropBlock);
     gcSpreadSheet1.DragDropBlockCompleted += new EventHandler<DragDropBlockCompletedEventArgs>(gcSpread1_DragDropBlockCompleted);
    
     void gcSpread1_DragDropBlock(object sender, DragDropBlockEventArgs e)
     {
           if (e.ToRow > 10 || e.ToColumn > 10)
               e.Cancel = true; 
     }
    
     void gcSpread1_DragDropBlockCompleted(object sender, DragDropBlockCompletedEventArgs e)
      {
           if (e.Copy == true && e.Insert == true)
               MessageBox.Show("Copied insert action has been completed");                     
      }
    Private Sub GcSpreadSheet1_DragDropBlock(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.DragDropBlockEventArgs)
            If (e.ToRow > 10 Or e.ToColumn > 10) Then
                e.Cancel = True
            End If
        End Sub
    
        Private Sub GcSpreadSheet1_DragDropBlockCompleted(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.DragDropBlockCompletedEventArgs)
            If (e.Copy = True And e.Insert = True) Then
                MessageBox.Show("Copied insert action has been completed")
            End If
        End Sub
    See Also