Copy Method (DefaultSheetAxisModel)

In This Topic

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

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Sub Copy( _
   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.Copy(fromIndex, toIndex, count)

public virtual void Copy( 
   int fromIndex,
   int toIndex,
   int count
)

Parameters

fromIndex: Row or column index at which to start copying rows or columns
toIndex: Row or column index at which to paste rows or columns
count: Number of rows or columns to copy

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 one is copied to column three.

Visual Basic
C#

Private Sub Page_Load(ByVal sender As System.Object,ByVal e As ystem.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.Copy(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.Copy(0,2,1);
}

Reference

DefaultSheetAxisModel Class
DefaultSheetAxisModel Members
Clear Method
Move Method
Swap Method