GrapeCity.Xaml.SpreadSheet.UI
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 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)
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

DragFillExtent Class
DragFillExtent Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options