Spread Silverlight Documentation
GrapeCity.Windows.SpreadSheet.UI.UndoRedo Namespace / DragFillUndoAction Class / DragFillUndoAction Constructor
The drag fill worksheet.
The drag fill extent information.
Example


In This Topic
    DragFillUndoAction Constructor
    In This Topic
    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 data.
    GcSpreadSheet1.CanUserUndo = true;        
    GcSpreadSheet1.Sheets[0].SetValue(10, 5, 1);
    var srange = new GrapeCity.Windows.SpreadSheet.Data.CellRange(10, 5, 1, 1);
    var frange = new GrapeCity.Windows.SpreadSheet.Data.CellRange(11, 5, 3, 1); 
    var dragFillExtent = new GrapeCity.Windows.SpreadSheet.UI.UndoRedo.DragFillExtent(srange, frange, GrapeCity.Windows.SpreadSheet.Data.AutoFillType.CopyCells, GrapeCity.Windows.SpreadSheet.Data.FillDirection.Down);
    var action = new GrapeCity.Windows.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.Windows.SpreadSheet.Data.CellRange(10, 5, 1, 1)
    Dim frange As New GrapeCity.Windows.SpreadSheet.Data.CellRange(11, 5, 3, 1)
    Dim dragFillExtent As New GrapeCity.Windows.SpreadSheet.UI.UndoRedo.DragFillExtent(srange, frange, GrapeCity.Windows.SpreadSheet.Data.AutoFillType.CopyCells, GrapeCity.Windows.SpreadSheet.Data.FillDirection.Down)
    Dim action As New GrapeCity.Windows.SpreadSheet.UI.UndoRedo.DragFillUndoAction(GcSpreadSheet1.Sheets(0), dragFillExtent)
    GcSpreadSheet1.DoCommand(action)
    See Also