Spread Silverlight Documentation
DragFillExtent Constructor
Example 


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

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

DragFillExtent Class
DragFillExtent Members

 

 


Copyright © GrapeCity, inc. All rights reserved.