Move Method (DefaultSheetAxisModel)

In This Topic

Moves one or more rows or columns and pastes them at the specified location.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Sub Move( _
   ByVal fromIndex As Integer, _
   ByVal toIndex As Integer, _
   ByVal count As Integer _
)

'Usage
 
Dim instance As DefaultSheetAxisModel
Dim fromIndex As Integer
Dim toIndex As Integer
Dim count As Integer
 
instance.Move(fromIndex, toIndex, count)

public virtual void Move( 
   int fromIndex,
   int toIndex,
   int 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

Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load

If(Me.IsPostBack)Then Return

Dim dm AsFarPoint.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

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);
}

Reference

DefaultSheetAxisModel Class
DefaultSheetAxisModel Members
Clear Method
Copy Method
Swap Method

Product Support Forum | Print this page