Spread Windows Forms 17
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / FillRange Method / FillRange(Int32,Int32,Int32,Int32,Int32,FillDirection,Boolean,Boolean) Method
Row index of the starting cell in the range to copy
Column index of the starting cell in the range to copy
Number of rows in the range to copy
Number of columns in the range to copy
Number of rows or columns into which to copy the specified range
Direction of fill (to copy the specified range)
Whether to fill data only (or also styles and spans)
Whether to fill in values only (or also formulas, notes, and tags)


In This Topic
    FillRange(Int32,Int32,Int32,Int32,Int32,FillDirection,Boolean,Boolean) Method
    In This Topic
    Fills a range of cells on this sheet by copying a specified range in the specified direction.
    Syntax
    'Declaration
     
    
    Public Overloads Sub FillRange( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer, _
       ByVal fillCount As Integer, _
       ByVal fillDirection As FillDirection, _
       ByVal dataOnly As Boolean, _
       ByVal valuesOnly As Boolean _
    ) 
    'Usage
     
    
    Dim instance As SheetView
    Dim row As Integer
    Dim column As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
    Dim fillCount As Integer
    Dim fillDirection As FillDirection
    Dim dataOnly As Boolean
    Dim valuesOnly As Boolean
     
    instance.FillRange(row, column, rowCount, columnCount, fillCount, fillDirection, dataOnly, valuesOnly)

    Parameters

    row
    Row index of the starting cell in the range to copy
    column
    Column index of the starting cell in the range to copy
    rowCount
    Number of rows in the range to copy
    columnCount
    Number of columns in the range to copy
    fillCount
    Number of rows or columns into which to copy the specified range
    fillDirection
    Direction of fill (to copy the specified range)
    dataOnly
    Whether to fill data only (or also styles and spans)
    valuesOnly
    Whether to fill in values only (or also formulas, notes, and tags)
    Exceptions
    ExceptionDescription
    Specified row index is not valid; must be between -1 and the total number of rows
    Specified column index is not valid; must be between -1 and the total number of columns
    Specified row count is not valid; must be -1 or between 0 and the total number of rows minus the current row index
    Specified column count is not valid; must be -1 or between 0 and the total number of columns minus the current column index
    Specified number of rows or columns (fill count) is not valid; must be -1 or between 0 and the total number of rows or columns
    Specified direction of the fill is not valid; must be one of the allowed enumeration settings
    Specified target range contains one or more cell spans so the operation cannot be completed.
    See Also