Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.UI.UndoRedo Namespace / DragFillExtent Class / DragFillExtent Constructor
The drag fill start range.
The drag fill end range.
The GrapeCity.Windows.SpreadSheet.UI.AutoFillType indicates the fill type.
The drag fill direction.
Example


In This Topic
    DragFillExtent Constructor
    In This Topic
    Creates a new instance of the DragFillExtent class.
    Syntax
    'Declaration
     
    Public Function New( _
       ByVal startRange As CellRange, _
       ByVal fillRange As CellRange, _
       ByVal autoFillType As AutoFillType, _
       ByVal fillDirection As FillDirection _
    )
    'Usage
     
    Dim startRange As CellRange
    Dim fillRange As CellRange
    Dim autoFillType As AutoFillType
    Dim fillDirection As FillDirection
     
    Dim instance As New DragFillExtent(startRange, fillRange, autoFillType, fillDirection)
    public DragFillExtent( 
       CellRange startRange,
       CellRange fillRange,
       AutoFillType autoFillType,
       FillDirection fillDirection
    )

    Parameters

    startRange
    The drag fill start range.
    fillRange
    The drag fill end range.
    autoFillType
    The GrapeCity.Windows.SpreadSheet.UI.AutoFillType indicates the fill type.
    fillDirection
    The drag fill direction.
    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