Move Method (DefaultSheetAxisModel)

Moves one or more rows or columns and pastes them at the specified location.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Sub Move( _
   ByVal fromIndex As Integer, _
   ByVal toIndex As Integer, _
   ByVal count As Integer _
)

'Usage
 
Dim instance As DefaultSheetAxisModel
Dim fromIndex As Integer
Dim toIndex As Integer
Dim count As Integer
 
instance.Move(fromIndex, toIndex, count)

public virtual void Move( 
   int fromIndex,
   int toIndex,
   int count
)

Parameters

fromIndex: Row or column index at which to start moving rows or columns
toIndex: Row or column index at which to paste rows or columns
count: Number of rows or columns to move

Exceptions

Exception	Description
System.IndexOutOfRangeException	Specified start index is not valid; must be between 0 and the total count
System.IndexOutOfRangeException	Specified destination index is not valid; must be between 0 and the total count
System.ArgumentException	Specified count is not valid; must be between 1 and the total count

Example

This example moves one or more columns and pastes them at the specified location.

FarPoint.Win.Spread.Model.DefaultSheetAxisModel dsam = new FarPoint.Win.Spread.Model.DefaultSheetAxisModel();
dsam = (FarPoint.Win.Spread.Model.DefaultSheetAxisModel)fpSpread1.ActiveSheet.Models.ColumnAxis;
dsam.SetSize(0, 120);
dsam.Move(0, 2, 1);

Visual Basic

Dim dsam As New FarPoint.Win.Spread.Model.DefaultSheetAxisModel()
dsam = FpSpread1.ActiveSheet.Models.ColumnAxis
dsam.SetSize(0, 120)
dsam.Move(0, 2, 1)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

DefaultSheetAxisModel Class
DefaultSheetAxisModel Members