Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overridable Sub Move( _ ByVal fromIndex As Integer, _ ByVal toIndex As Integer, _ ByVal count As Integer _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As DefaultSheetAxisModel Dim fromIndex As Integer Dim toIndex As Integer Dim count As Integer instance.Move(fromIndex, toIndex, 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.
| C# | Copy Code |
|---|---|
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 | Copy Code |
|---|---|
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 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