Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / AutoSortColumn Method / AutoSortColumn(Int32,Boolean,Boolean) Method
Column index
Whether sort is ascending (or else descending)
Whether to display the sort indicator
Example


In This Topic
    AutoSortColumn(Int32,Boolean,Boolean) Method
    In This Topic
    Automatically sorts the rows of a sheet according to the specified column in the specified order and uses the sort indicator as specified.
    Syntax
    'Declaration
     
    Public Overloads Sub AutoSortColumn( _
       ByVal column As Integer, _
       ByVal ascending As Boolean, _
       ByVal showIndicator As Boolean _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim column As Integer
    Dim ascending As Boolean
    Dim showIndicator As Boolean
     
    instance.AutoSortColumn(column, ascending, showIndicator)
    public void AutoSortColumn( 
       int column,
       bool ascending,
       bool showIndicator
    )

    Parameters

    column
    Column index
    ascending
    Whether sort is ascending (or else descending)
    showIndicator
    Whether to display the sort indicator
    Remarks
    See the explanation in the AutoSortColumn methods overview.
    Example

    This example sets whether to allow automatic sorting in the specified column, if it should be sorted in ascending order, and whether to show the sort indicator.

    Random r = new Random();
    int i, j;
    for (i = 0; i<= 50; i++)
    {
        for (j = 0; j<=3; j++)
            fpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString());
    }
    fpSpread1.ActiveSheet.AutoSortColumn(0, true, false);
    Dim r As New Random()
    Dim i, j As Integer
    For i = 0 To 50
        For j = 0 To 3
            FpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString())
        Next j
    Next i
    FpSpread1.ActiveSheet.AutoSortColumn(0, True, False)
    See Also