DragDropUndoAction Constructor

Visual Basic
C#

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

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

public DragDropUndoAction( 
   Worksheet sheet,
   DragDropExtent dragMoveExtent,
   System.bool copy,
   System.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#

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

VB.NET

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

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

DragDropUndoAction Class
DragDropUndoAction Members