MoveTo(Int32,Int32,Int32,Int32,Int32,Int32,CopyToOption) Method

Visual Basic
C#

'Declaration
 
Public Sub MoveTo( _
   ByVal fromRow As Integer, _
   ByVal fromColumn As Integer, _
   ByVal toRow As Integer, _
   ByVal toColumn As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer, _
   ByVal option As CopyToOption _
)

'Usage
 
Dim instance As Worksheet
Dim fromRow As Integer
Dim fromColumn As Integer
Dim toRow As Integer
Dim toColumn As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim option As CopyToOption
 
instance.MoveTo(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount, option)

public void MoveTo( 
   int fromRow,
   int fromColumn,
   int toRow,
   int toColumn,
   int rowCount,
   int columnCount,
   CopyToOption option
)

Parameters

fromRow: The source row.
fromColumn: The source column.
toRow: The target row.
toColumn: The target column.
rowCount: The row count.
columnCount: The column count.
option: The move option.

This example uses the MoveTo method.

C#
VB.NET

gcSpreadSheet1.Sheets[0].Cells[0, 0, 2, 2].Text = "test";
gcSpreadSheet1.Sheets[0].Cells[0, 0].Tag = "Tag 1";
gcSpreadSheet1.Sheets[0].MoveTo(0, 0, 5, 5, 2, 2, GrapeCity.Xaml.SpreadSheet.Data.CopyToOption.All);

GcSpreadSheet1.Sheets(0).Cells(0, 0, 2, 2).Text = "test"
GcSpreadSheet1.Sheets(0).Cells(0, 0).Tag = "Tag 1"
GcSpreadSheet1.Sheets(0).MoveTo(0, 0, 5, 5, 2, 2, GrapeCity.Xaml.SpreadSheet.Data.CopyToOption.All)

Target Platforms: Windows Server 2012, Windows RT

Reference

Worksheet Class
Worksheet Members