DragDropUndoAction Constructor

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal sheet As Worksheet, _
   ByVal dragMoveExtent As DragDropExtent, _
   ByVal copy As Boolean, _
   ByVal insert As Boolean, _
   ByVal option As CopyToOption _
)

'Usage
 
Dim sheet As Worksheet
Dim dragMoveExtent As DragDropExtent
Dim copy As Boolean
Dim insert As Boolean
Dim option As CopyToOption
 
Dim instance As New DragDropUndoAction(sheet, dragMoveExtent, copy, insert, option)

public DragDropUndoAction( 
   Worksheet sheet,
   DragDropExtent dragMoveExtent,
   bool copy,
   bool insert,
   CopyToOption option
)

Parameters

sheet: The worksheet to drag and drop.
dragMoveExtent: The drag drop extent information.
copy: if set to true copy; otherwise, false.
insert: if set to true inserts the drag data in the drop row or column.
option: The GrapeCity.Windows.SpreadSheet.Data.CopyToOption indicates the content type to drag and drop.

This example drags and drops data.

C#
Visual Basic

//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)

Reference

DragDropUndoAction Class
DragDropUndoAction Members