SwapRows Method

Swaps the a range of rows with another range of rows.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub SwapRows( _
   ByVal fromRow As Integer, _
   ByVal toRow As Integer, _
   ByVal count As Integer _
)

'Usage
 
Dim instance As DefaultSheetSpanModel
Dim fromRow As Integer
Dim toRow As Integer
Dim count As Integer
 
instance.SwapRows(fromRow, toRow, count)

public void SwapRows( 
   int fromRow,
   int toRow,
   int count
)

Parameters

fromRow: Row index at which to start swap
toRow: Row index at which to swap rows
count: Number of rows to swap

Example

This example takes the second span in column one and swaps it to the seventh row.

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.SwapRows(4, 6, 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.SwapRows(4, 6, 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

DefaultSheetSpanModel Class
DefaultSheetSpanModel Members