GrapeCity.Xaml.SpreadSheet.UI
DragFillUndoAction Constructor
Example 


GrapeCity.Xaml.SpreadSheet.UI.UndoRedo Namespace > DragFillUndoAction Class : DragFillUndoAction Constructor
The drag fill worksheet.
The drag fill extent information.
Creates a new instance of the DragFillUndoAction class.
Syntax
'Declaration
 
Public Function New( _
   ByVal workSheet As Worksheet, _
   ByVal dragFillExtent As DragFillExtent _
)
'Usage
 
Dim workSheet As Worksheet
Dim dragFillExtent As DragFillExtent
 
Dim instance As New DragFillUndoAction(workSheet, dragFillExtent)
public DragFillUndoAction( 
   Worksheet workSheet,
   DragFillExtent dragFillExtent
)

Parameters

workSheet
The drag fill worksheet.
dragFillExtent
The drag fill extent information.
Example
This example drags and fills a range.
GcSpreadSheet1.CanUserUndo = true;        
GcSpreadSheet1.Sheets[0].SetValue(10, 5, 1);
var srange = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(10, 5, 1, 1);
var frange = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(11, 5, 3, 1); 
var dragFillExtent = new GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.DragFillExtent(srange, frange, GrapeCity.Xaml.SpreadSheet.Data.AutoFillType.CopyCells, GrapeCity.Xaml.SpreadSheet.Data.FillDirection.Down);
var action = new GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.DragFillUndoAction(GcSpreadSheet1.Sheets[0], dragFillExtent);
GcSpreadSheet1.DoCommand(action);
GcSpreadSheet1.CanUserUndo = True
GcSpreadSheet1.Sheets(0).SetValue(10, 5, 1)
Dim srange As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(10, 5, 1, 1)
Dim frange As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(11, 5, 3, 1)
Dim dragFillExtent As New GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.DragFillExtent(srange, frange, GrapeCity.Xaml.SpreadSheet.Data.AutoFillType.CopyCells, GrapeCity.Xaml.SpreadSheet.Data.FillDirection.Down)
Dim action As New GrapeCity.Xaml.SpreadSheet.UI.UndoRedo.DragFillUndoAction(GcSpreadSheet1.Sheets(0), dragFillExtent)
GcSpreadSheet1.DoCommand(action)
See Also

Reference

DragFillUndoAction Class
DragFillUndoAction Members