DragFillExtent Constructor

Visual Basic
C#

'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.

This example drags and fills data.

C#

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

VB.NET

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)

Reference

DragFillExtent Class
DragFillExtent Members