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 sets the size of the first two column headers, then in a button click event, column 1 is moved to column 3.
| 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.Move(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.Move(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