Spread Silverlight Documentation
DragFillUndoAction Constructor
Example 


The drag fill worksheet.
The drag fill extent information.
Creates a new instance of the DragFillUndoAction class.
Syntax
'Declaration
 
Public Function New( _
   ByVal workSheet As Worksheet, _
   ByVal dragFillExtent As DragFillExtent _
)
'Usage
 
Dim workSheet As Worksheet
Dim dragFillExtent As DragFillExtent
 
Dim instance As New DragFillUndoAction(workSheet, dragFillExtent)
public DragFillUndoAction( 
   Worksheet workSheet,
   DragFillExtent dragFillExtent
)

Parameters

workSheet
The drag fill worksheet.
dragFillExtent
The drag fill extent information.
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

DragFillUndoAction Class
DragFillUndoAction Members

 

 


Copyright © GrapeCity, inc. All rights reserved.