SortState.Sort(Int32, Boolean) Method

Sort a specified column in the specified order.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void Sort(
    int columnIndex,
    bool descendingOrder
)

VB.NET

Sub Sort(
    columnIndex As Integer,
    descendingOrder As Boolean
)

Parameters

Name	Type	Description
columnIndex	Int32	An index of the column to sort. This is zero-based index of columns to which AutoFilter is applied.
descendingOrder	Boolean	true to sort in descending order; otherwise, false.

Example

View Example

AutoFilterActions.cs

Worksheet worksheet = workbook.Worksheets["Regional sales"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Enable filtering for the specified cell range.
CellRange range = worksheet["B2:E23"];
worksheet.AutoFilter.Apply(range);

// Sort the data in descending order by the first column.
worksheet.AutoFilter.SortState.Sort(0, true);

AutoFilterActions.vb

Dim worksheet As Worksheet = workbook.Worksheets("Regional sales")
workbook.Worksheets.ActiveWorksheet = worksheet

' Enable filtering for the specified cell range.
Dim range As CellRange = worksheet("B2:E23")
worksheet.AutoFilter.Apply(range)

' Sort the data in descending order by the first column.
worksheet.AutoFilter.SortState.Sort(0, True)

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Sort(Int32, Boolean) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

spreadsheet-document-api-examples-part2/CS/SpreadsheetDocServerAPIPart2/CodeExamples/AutoFilterActions.cs#L33

// in descending order by column "A".
worksheet.AutoFilter.SortState.Sort(0, true);
#endregion #FilterAndSortBySingleColumn

winforms-spreadsheetcontrol-api-part-2/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/AutoFilterActions.cs#L59

// Sort the data in descending order by the first column.
worksheet.AutoFilter.SortState.Sort(0, true);
#endregion #FilterSortBySingleColumn

VB.NET

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/CodeExamples/AutoFilterActions.vb#L28

            ' in descending order by column "A".
            worksheet.AutoFilter.SortState.Sort(0, True)
#End Region  ' #FilterAndSortBySingleColumn

winforms-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/AutoFilterActions.vb#L56

                ' Sort the data in descending order by the first column.
                worksheet.AutoFilter.SortState.Sort(0, True)
'                #End Region ' #FilterSortBySingleColumn

wpf-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/AutoFilterActions.vb#L55

                ' Sort the data in descending order by the first column.
                worksheet.AutoFilter.SortState.Sort(0, True)
'                #End Region ' #FilterSortBySingleColumn