Spread Windows Forms 14.0
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / CopyRange(Int32,Int32,Int32,Int32,Int32,Int32,Boolean) Method
Row index of top-left cell in block to copy
Column index of top-left cell in block to copy
Row index of top-left cell in destination
Column index of top-left cell in destination
Number of rows in the block
Number of columns in the block
Whether only the data is copied, or the data and formatting


In This Topic
    CopyRange(Int32,Int32,Int32,Int32,Int32,Int32,Boolean) Method
    In This Topic
    Copies the data, formatting, formulas, and notes from a block of cells on the sheet to a new location.
    Syntax
    'Declaration
     
    
    Public Sub CopyRange( _
       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.CopyRange(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount, dataOnly)

    Parameters

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