GrapeCity.Xaml.SpreadSheet.UI
DragDropUndoAction Constructor
Example 


The worksheet to drag and drop.
The drag drop extent information.
if set to true copy; otherwise, false.
if set to true inserts the drag data in the drop row or column.
The GrapeCity.Windows.SpreadSheet.Data.CopyToOption indicates the content type to drag and drop.
Initializes a new instance of the DragDropUndoAction class.
Syntax
'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.
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)
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

DragDropUndoAction Class
DragDropUndoAction Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options