GrapeCity.Xaml.SpreadSheet.UI
DragDropExtent Constructor
Example 


GrapeCity.Xaml.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.
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.Xaml.SpreadSheet.UI.UndoRedo.DragDropExtent(2, 1, 12, 2, 2, 2);
var action = new GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.DragDropUndoAction(GcSpreadSheet1.Sheets[0], dd, true, false, GrapeCity.Xaml.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.Xaml.SpreadSheet.UI.UndoRedo.DragDropExtent(2, 1, 12, 2, 2, 2)
Dim action As New GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.DragDropUndoAction(GcSpreadSheet1.Sheets(0), dd, True, False, GrapeCity.Xaml.SpreadSheet.Data.CopyToOption.Value)
GcSpreadSheet1.DoCommand(action)
See Also

Reference

DragDropExtent Class
DragDropExtent Members