Spread Windows Forms 6.0 Product Documentation
Move Method
See Also Example Support Options

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class : Move Method

Visual Basic (Declaration)
Visual Basic (Usage)
C#

fromRow: Row index of starting position of range to move

fromColumn: Column index of starting position of range to move

toRow: Row index of starting position of destination

toColumn: Column index of starting position of destination

rowCount: Number of rows in range

columnCount: Number of columns in range

Moves the data from a range of cells to the specified location.

Syntax

Visual Basic (Declaration)
Public Sub Move( _ ByVal fromRow As Integer, _ ByVal fromColumn As Integer, _ ByVal toRow As Integer, _ ByVal toColumn As Integer, _ ByVal rowCount As Integer, _ ByVal columnCount As Integer _ )

Visual Basic (Declaration)

Public Sub Move( _
   ByVal fromRow As Integer, _
   ByVal fromColumn As Integer, _
   ByVal toRow As Integer, _
   ByVal toColumn As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
)

Visual Basic (Usage)	Copy Code
Dim instance As DefaultSheetDataModel Dim fromRow As Integer Dim fromColumn As Integer Dim toRow As Integer Dim toColumn As Integer Dim rowCount As Integer Dim columnCount As Integer instance.Move(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount)

Visual Basic (Usage)

Copy Code

Dim instance As DefaultSheetDataModel
Dim fromRow As Integer
Dim fromColumn As Integer
Dim toRow As Integer
Dim toColumn As Integer
Dim rowCount As Integer
Dim columnCount As Integer
 
instance.Move(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount)

C#
public void Move( int fromRow, int fromColumn, int toRow, int toColumn, int rowCount, int columnCount )

Parameters

fromRow: Row index of starting position of range to move
fromColumn: Column index of starting position of range to move
toRow: Row index of starting position of destination
toColumn: Column index of starting position of destination
rowCount: Number of rows in range
columnCount: Number of columns in range

Exceptions

Exception	Description
System.ArgumentException	Specified starting and ending row or row count is not valid
System.ArgumentException	Specified starting and ending column or column count is not valid

Example

Visual Basic	Copy Code
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(8, 8) FpSpread1.ActiveSheet.Models.Data = dataModel dataModel.SetValue(0, 0, "Let's") dataModel.SetValue(0, 1, "Move") dataModel.Move(0, 0, 3, 2, 1, 2)

Visual Basic

Copy Code

Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(8, 8)
FpSpread1.ActiveSheet.Models.Data = dataModel
dataModel.SetValue(0, 0, "Let's")
dataModel.SetValue(0, 1, "Move")
dataModel.Move(0, 0, 3, 2, 1, 2)

C#	Copy Code
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(8, 8); fpSpread1.ActiveSheet.Models.Data = dataModel; dataModel.SetValue(0, 0, "Let's"); dataModel.SetValue(0, 1, "Move"); dataModel.Move(0, 0, 3, 2, 1, 2);

Copy Code

FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(8, 8);
fpSpread1.ActiveSheet.Models.Data = dataModel;
dataModel.SetValue(0, 0, "Let's");
dataModel.SetValue(0, 1, "Move");
dataModel.Move(0, 0, 3, 2, 1, 2);

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Syntax

Parameters

Exceptions

Example

Requirements

See Also

Reference