FarPoint.Win.Spread.SheetView.SwapRange

SwapRange Method

SwapRange(int, int, int, int, int, int, bool)

Swaps the data and formatting in a block of cells on this sheet with another block of cells on this sheet.

Declaration

public void SwapRange(int fromRow, int fromColumn, int toRow, int toColumn, int rowCount, int columnCount, bool dataOnly)

Public Sub SwapRange(fromRow As Integer, fromColumn As Integer, toRow As Integer, toColumn As Integer, rowCount As Integer, columnCount As Integer, dataOnly As Boolean)

Parameters

Type	Name	Description
int	fromRow	Row index of the top-left cell in the block from which to swap
int	fromColumn	Column index of the top-left cell in the block from which to swap
int	toRow	Row index of the top-left cell in the destination block
int	toColumn	Column index of the top-left cell in the destination block
int	rowCount	Number of rows in the block of cells
int	columnCount	Number of columns in the block of cells
bool	dataOnly	Whether only the data is copied, or the data and formatting

Exceptions

Type	Condition
InvalidOperationException	Operation is not valid; cannot swap entire sheet of cells
InvalidOperationException	Operation is not valid; cannot swap entire columns over partial columns
InvalidOperationException	Operation is not valid; cannot swap entire rows over partial rows
InvalidOperationException	Operation is not valid; cannot swap a range of cells over part of a spanned cell

SwapRange Method
SwapRange(int, int, int, int, int, int, bool)
Declaration
Parameters
Exceptions