DragFillExtent Constructor (DragFillExtent)

DragFillExtent Constructor

In This Topic

Creates a new instance of the DragFillExtent class.

Syntax

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.

Example

This example drags and fills a range.

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

Product Support Forum | Print this page