Spread Windows Forms 7.0 Product Documentation
Swap Method
See Also Example Support Options

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetStyleModel Class : Swap Method

Visual Basic (Declaration)
Visual Basic (Usage)
C#

fromRow: Row index of first cell from which to begin swap

fromColumn: Column index of first cell from which to begin swap

toRow: Row index of first cell of destination of the swap

toColumn: Column index of first cell of destination of the swap

rowCount: Number of rows to swap

columnCount: Number of columns to swap

Swaps the direct styles in the specified range with the direct styles from another specified range.

Syntax

Visual Basic (Declaration)
Public Overridable Sub Swap( _ ByVal fromRow As Integer, _ ByVal fromColumn As Integer, _ ByVal toRow As Integer, _ ByVal toColumn As Integer, _ ByVal rowCount As Integer, _ ByVal columnCount As Integer _ )

Visual Basic (Declaration)

Public Overridable Sub Swap( _
   ByVal fromRow As Integer, _
   ByVal fromColumn As Integer, _
   ByVal toRow As Integer, _
   ByVal toColumn As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
)

Visual Basic (Usage)	Copy Code
Dim instance As DefaultSheetStyleModel Dim fromRow As Integer Dim fromColumn As Integer Dim toRow As Integer Dim toColumn As Integer Dim rowCount As Integer Dim columnCount As Integer instance.Swap(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount)

Visual Basic (Usage)

Copy Code

Dim instance As DefaultSheetStyleModel
Dim fromRow As Integer
Dim fromColumn As Integer
Dim toRow As Integer
Dim toColumn As Integer
Dim rowCount As Integer
Dim columnCount As Integer
 
instance.Swap(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount)

C#
public virtual void Swap( int fromRow, int fromColumn, int toRow, int toColumn, int rowCount, int columnCount )

Parameters

fromRow: Row index of first cell from which to begin swap
fromColumn: Column index of first cell from which to begin swap
toRow: Row index of first cell of destination of the swap
toColumn: Column index of first cell of destination of the swap
rowCount: Number of rows to swap
columnCount: Number of columns to swap

Example

This example swaps styles between locations.

C#	Copy Code
FarPoint.Win.Spread.Model.DefaultSheetStyleModel defstyleModel = new FarPoint.Win.Spread.Model.DefaultSheetStyleModel(); FarPoint.Win.Spread.StyleInfo sInfo = new FarPoint.Win.Spread.StyleInfo(); defstyleModel = (FarPoint.Win.Spread.Model.DefaultSheetStyleModel)fpSpread1.ActiveSheet.Models.Style; sInfo.BackColor = Color.LightBlue; defstyleModel.SetDirectInfo(0, 0, sInfo); defstyleModel.Swap(0, 0, 3, 0 , 1, 1);

Copy Code

FarPoint.Win.Spread.Model.DefaultSheetStyleModel defstyleModel = new FarPoint.Win.Spread.Model.DefaultSheetStyleModel();
FarPoint.Win.Spread.StyleInfo sInfo = new FarPoint.Win.Spread.StyleInfo();
defstyleModel = (FarPoint.Win.Spread.Model.DefaultSheetStyleModel)fpSpread1.ActiveSheet.Models.Style;
sInfo.BackColor = Color.LightBlue;
defstyleModel.SetDirectInfo(0, 0, sInfo);
defstyleModel.Swap(0, 0, 3, 0 , 1, 1);

Visual Basic	Copy Code
Dim defstyleModel As New FarPoint.Win.Spread.Model.DefaultSheetStyleModel() Dim sInfo As New FarPoint.Win.Spread.StyleInfo() defstyleModel = FpSpread1.ActiveSheet.Models.Style sInfo.BackColor = Color.LightBlue defstyleModel.SetDirectInfo(0, 0, sInfo) defstyleModel.Swap(0, 0, 3, 0, 1, 1)

Visual Basic

Copy Code

Dim defstyleModel As New FarPoint.Win.Spread.Model.DefaultSheetStyleModel()
Dim sInfo As New FarPoint.Win.Spread.StyleInfo()
defstyleModel = FpSpread1.ActiveSheet.Models.Style
sInfo.BackColor = Color.LightBlue
defstyleModel.SetDirectInfo(0, 0, sInfo)
defstyleModel.Swap(0, 0, 3, 0, 1, 1)

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

Syntax

Parameters

Example

Requirements

See Also

Reference