Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.UI.UndoRedo Namespace / DragDropExtent Class / DragDropExtent Constructor
The from row index.
The from column index.
The to row index.
The to column index.
The drag drop row count.
The drag drop column count.
Example


In This Topic
    DragDropExtent Constructor
    In This Topic
    Creates a new instance of the DragDropExtent class.
    Syntax
    'Declaration
     
    Public Function New( _
       ByVal fromRow As Integer, _
       ByVal fromColumn As Integer, _
       ByVal toRow As Integer, _
       ByVal toColumn As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer _
    )
    'Usage
     
    Dim fromRow As Integer
    Dim fromColumn As Integer
    Dim toRow As Integer
    Dim toColumn As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
     
    Dim instance As New DragDropExtent(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount)
    public DragDropExtent( 
       int fromRow,
       int fromColumn,
       int toRow,
       int toColumn,
       int rowCount,
       int columnCount
    )

    Parameters

    fromRow
    The from row index.
    fromColumn
    The from column index.
    toRow
    The to row index.
    toColumn
    The to column index.
    rowCount
    The drag drop row count.
    columnCount
    The drag drop column count.
    Example
    This example drags and drops data.
    //Add data
    for (var col = 1; col < 6; col++)
    {
        for (var row = 2; row < 11; row++)
        {
            GcSpreadSheet1.Sheets[0].SetValue(row, col, row + col);
        }
    }
    
    GcSpreadSheet1.CanUserUndo = true;
    var dd = new GrapeCity.Windows.SpreadSheet.UI.UndoRedo.DragDropExtent(2, 1, 12, 2, 2, 2);
    var action = new GrapeCity.Windows.SpreadSheet.UI.UndoRedo.DragDropUndoAction(GcSpreadSheet1.Sheets[0], dd, true, false, GrapeCity.Windows.SpreadSheet.Data.CopyToOption.Value);
    GcSpreadSheet1.DoCommand(action);
    'Add data
    For col As Integer = 1 To 6
        For row As Integer = 2 To 11
            GcSpreadSheet1.Sheets(0).SetValue(row, col, row + col)
        Next
    Next
    
    GcSpreadSheet1.CanUserUndo = True
    Dim dd As New GrapeCity.Windows.SpreadSheet.UI.UndoRedo.DragDropExtent(2, 1, 12, 2, 2, 2)
    Dim action As New GrapeCity.Windows.SpreadSheet.UI.UndoRedo.DragDropUndoAction(GcSpreadSheet1.Sheets(0), dd, True, False, GrapeCity.Windows.SpreadSheet.Data.CopyToOption.Value)
    GcSpreadSheet1.DoCommand(action)
    See Also