FarPoint.Win.Spread.SheetView.MoveRange

MoveRange Method

MoveRange(int, int, int, int, int, int, bool)

Moves the data, formatting, formulas, and notes from a block of cells on this sheet to a new location.

Declaration

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

Public Sub MoveRange(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 top-left cell in block to move
int	fromColumn	Column index of top-left cell in block to move
int	toRow	Row index for destination of upper-left cell in block
int	toColumn	Column index for destination of upper-left cell in block
int	rowCount	Number of rows in the block
int	columnCount	Number of columns in the block
bool	dataOnly	Whether data only or data with formatting are swapped

Exceptions

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

MoveRange Method