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 sets the size of the first two column headers, then in a button click event, column 3 is swapped with column 1.
| Visual Basic | Copy Code |
|---|---|
PrivateSubPage_Load(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesMyBase.Load If(Me.IsPostBack)ThenReturn DimdmAsFarPoint.Web.Spread.Model.DefaultSheetAxisModel=CType(FpSpread1.ActiveSheetView.ColumnAxisModel,FarPoint.Web.Spread.Model.DefaultSheetAxisModel) dm.SetSize(0,140) dm.SetSize(1,50) EndSub PrivateSubButton1_Click(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesButton1.Click DimdmAsFarPoint.Web.Spread.Model.DefaultSheetAxisModel=CType(FpSpread1.ActiveSheetView.ColumnAxisModel,FarPoint.Web.Spread.Model.DefaultSheetAxisModel) dm.Swap(0,2,1) EndSub | |
| C# | Copy Code |
|---|---|
PrivatevoidPage_Load(objectsender,System.EventArgse)
{
If(this.IsPostBack)Return;
FarPoint.Web.Spread.Model.DefaultSheetAxisModeldm=(FarPoint.Web.Spread.Model.DefaultSheetAxisModel)FpSpread1.ActiveSheetView.ColumnAxisModel;
dm.SetSize(0,140);
dm.SetSize(1,50);
}
PrivatevoidButton1_Click(objectsender,System.EventArgse)
{
FarPoint.Web.Spread.Model.DefaultSheetAxisModeldm=(FarPoint.Web.Spread.Model.DefaultSheetAxisModel)FpSpread1.ActiveSheetView.ColumnAxisModel;
dm.Swap(0,2,1);
} | |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family