CopyColumns Method

In This Topic

Copies columns and pastes them at the specified location.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub CopyColumns( _
   ByVal fromColumn As Integer, _
   ByVal toColumn As Integer, _
   ByVal count As Integer _
)

'Usage
 
Dim instance As DefaultSheetSpanModel
Dim fromColumn As Integer
Dim toColumn As Integer
Dim count As Integer
 
instance.CopyColumns(fromColumn, toColumn, count)

public void CopyColumns( 
   int fromColumn,
   int toColumn,
   int count
)

Parameters

fromColumn: Column index at which to start copying
toColumn: Column index at which to paste columns
count: Number of columns to copy

Example

This example adds a span to the SpanModel of the active sheet. In the click event of a button, the columns in the span are copied to another location.

C#
Visual Basic

private void Page_Load(object sender,System.EventArgs e)
{
if(this.IsPostBack)return;

FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.RowCount=10;
FarPoint.Web.Spread.Model.ISheetSpanModel model=FpSpread1.ActiveSheetView.SpanModel;
model.Add(0,0,3,3);
}

private void Button1_Click(object sender,System.EventArgs e)
{
FarPoint.Web.Spread.Model.DefaultSheetSpanModel model=(FarPoint.Web.Spread.Model.DefaultSheetSpanModel)FpSpread1.ActiveSheetView.SpanModel;
model.CopyColumns(0,4,3);
}

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

FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.RowCount=10
Dim model As FarPoint.Web.Spread.Model.ISheetSpanModel=FpSpread1.ActiveSheetView.SpanModel
model.Add(0,0,3,3)
End Sub

Private Sub Button1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles Button1.Click
Dim model As FarPoint.Web.Spread.Model.DefaultSheetSpanModel=FpSpread1.ActiveSheetView.SpanModel
model.CopyColumns(0,4,3)
End Sub

Reference

DefaultSheetSpanModel Class
DefaultSheetSpanModel Members
Copy Method
CopyRows Method
MoveColumns Method
SwapColumns Method