SwapColumns Method

Swaps a range of columns with another range of columns.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub SwapColumns( _
   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.SwapColumns(fromColumn, toColumn, count)

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

Parameters

fromColumn: Column index at which to start swap
toColumn: Column index at which to swap columns
count: Number of columns to swap

Example

This example takes the spans in column one and swaps them to the fourth column.

FarPoint.Win.Spread.Model.DefaultSheetSpanModel defspanModel = new FarPoint.Win.Spread.Model.DefaultSheetSpanModel();
fpSpread1.ActiveSheet.Models.Span = defspanModel;
defspanModel.Add(0, 0, 2, 2);
defspanModel.Add(4, 0, 2, 2);
defspanModel.SwapColumns(0, 4, 2);

Visual Basic

Dim defspanModel As New FarPoint.Win.Spread.Model.DefaultSheetSpanModel()
FpSpread1.ActiveSheet.Models.Span = defspanModel
defspanModel.Add(0, 0, 2, 2)
defspanModel.Add(4, 0, 2, 2)
defspanModel.SwapColumns(0, 4, 2)

Reference

DefaultSheetSpanModel Class
DefaultSheetSpanModel Members