Copy Method (DefaultSheetAxisModel)

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 copies the values from the specified rows and pastes them into the designated rows.

FarPoint.Win.Spread.Model.DefaultSheetAxisModel dsam = new FarPoint.Win.Spread.Model.DefaultSheetAxisModel();
dsam = (FarPoint.Win.Spread.Model.DefaultSheetAxisModel)fpSpread1.ActiveSheet.Models.RowAxis;
dsam.Copy(0, 2, 2);

Visual Basic

Dim dsam As New FarPoint.Win.Spread.Model.DefaultSheetAxisModel()
dsam = FpSpread1.ActiveSheet.Models.RowAxis
dsam.Copy(0, 2, 2)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

DefaultSheetAxisModel Class
DefaultSheetAxisModel Members