Spread Windows Forms 14.0
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / MoveRange Method
Row index of top-left cell in block to move
Column index of top-left cell in block to move
Row index for destination of upper-left cell in block
Column index for destination of upper-left cell in block
Number of rows in the block
Number of columns in the block
Whether data only or data with formatting are swapped


In This Topic
    MoveRange Method
    In This Topic
    Moves the data, formatting, formulas, and notes from a block of cells on this sheet to a new location.
    Syntax
    'Declaration
     
    
    Public Sub MoveRange( _
       ByVal fromRow As Integer, _
       ByVal fromColumn As Integer, _
       ByVal toRow As Integer, _
       ByVal toColumn As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer, _
       ByVal dataOnly As Boolean _
    ) 
    'Usage
     
    
    Dim instance As SheetView
    Dim fromRow As Integer
    Dim fromColumn As Integer
    Dim toRow As Integer
    Dim toColumn As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
    Dim dataOnly As Boolean
     
    instance.MoveRange(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount, dataOnly)

    Parameters

    fromRow
    Row index of top-left cell in block to move
    fromColumn
    Column index of top-left cell in block to move
    toRow
    Row index for destination of upper-left cell in block
    toColumn
    Column index for destination of upper-left cell in block
    rowCount
    Number of rows in the block
    columnCount
    Number of columns in the block
    dataOnly
    Whether data only or data with formatting are swapped
    Exceptions
    ExceptionDescription
    Operation is not valid; cannot move entire sheet of cells
    Operation is not valid; cannot move entire columns over partial columns
    Operation is not valid; cannot move entire rows over partial rows
    Operation is not valid; cannot move a range of cells over part of a spanned cell
    See Also