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 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