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 |
|---|---|
Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load If(Me.IsPostBack)Then Return Dim dm As FarPoint.Web.Spread.Model.DefaultSheetAxisModel=CType(FpSpread1.ActiveSheetView.ColumnAxisModel,FarPoint.Web.Spread.Model.DefaultSheetAxisModel) dm.SetSize(0,140) dm.SetSize(1,50) End Sub Private Sub Button1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles Button1.Click Dim dm As FarPoint.Web.Spread.Model.DefaultSheetAxisModel=CType(FpSpread1.ActiveSheetView.ColumnAxisModel,FarPoint.Web.Spread.Model.DefaultSheetAxisModel) dm.Move(0,2,1) End Sub | |
| C# | Copy Code |
|---|---|
private void Page_Load(object sender,System.EventArgs e) { if(this.IsPostBack)return; FarPoint.Web.Spread.Model.DefaultSheetAxisModel dm=(FarPoint.Web.Spread.Model.DefaultSheetAxisModel)FpSpread1.ActiveSheetView.ColumnAxisModel; dm.SetSize(0,140); dm.SetSize(1,50); } private void Button1_Click(object sender,System.EventArgs e) { FarPoint.Web.Spread.Model.DefaultSheetAxisModel dm=(FarPoint.Web.Spread.Model.DefaultSheetAxisModel)FpSpread1.ActiveSheetView.ColumnAxisModel; dm.Move(0,2,1); } | |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6