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