Spread Windows Forms 17
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / SortRange Method
Index of the starting row of the block of cells to sort
Index of the starting column of the block of cells to sort
Number of rows in the block of cells
Number of columns in the block of cells
Whether to sort by rows (or by columns)
SortInfo object with sort criteria and how to perform sort


In This Topic
    SortRange Method
    In This Topic
    Sorts a range of cells on this sheet in the data model.
    Syntax
    'Declaration
     
    
    Public Function SortRange( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer, _
       ByVal byRows As Boolean, _
       ByVal sortInfo() As SortInfo _
    ) As Boolean
    'Usage
     
    
    Dim instance As SheetView
    Dim row As Integer
    Dim column As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
    Dim byRows As Boolean
    Dim sortInfo() As SortInfo
    Dim value As Boolean
     
    value = instance.SortRange(row, column, rowCount, columnCount, byRows, sortInfo)

    Parameters

    row
    Index of the starting row of the block of cells to sort
    column
    Index of the starting column of the block of cells to sort
    rowCount
    Number of rows in the block of cells
    columnCount
    Number of columns in the block of cells
    byRows
    Whether to sort by rows (or by columns)
    sortInfo
    SortInfo object with sort criteria and how to perform sort
    See Also