Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overridable Sub Swap( _ 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.Swap(fromIndex, toIndex, count) | |
Parameters
- fromIndex
- Row or column index at which to start swapping rows or columns
- toIndex
- Row or column index at which to swap rows or columns
- count
- Number of rows or columns to swap
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 swaps the designated columns.
| 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.Swap(0, 1, 1); | |
| Visual Basic | Copy Code |
|---|---|
Dim dsam As New FarPoint.Win.Spread.Model.DefaultSheetAxisModel() dsam = FpSpread1.ActiveSheet.Models.ColumnAxis dsam.SetSize(0, 120) dsam.Swap(0, 1, 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