SortState.Sort(IList<SortCondition>) Method

Sort columns as specified in sort conditions.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void Sort(
    IList<SortCondition> conditions
)

VB.NET

Sub Sort(
    conditions As IList(Of SortCondition)
)

Parameters

Name	Type	Description
conditions	IList<SortCondition>	A collection of SortCondition objects.

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 and third columns.
List<SortCondition> sortConditions = new List<SortCondition>();
sortConditions.Add(new SortCondition(0, true));
sortConditions.Add(new SortCondition(2, true));
worksheet.AutoFilter.SortState.Sort(sortConditions);

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 and third columns.
Dim sortConditions As New List(Of SortCondition)()
sortConditions.Add(New SortCondition(0, True))
sortConditions.Add(New SortCondition(2, True))
worksheet.AutoFilter.SortState.Sort(sortConditions)

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Sort(IList<SortCondition>) 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#L55

sortConditions.Add(new SortCondition(2, color, false));
worksheet.AutoFilter.SortState.Sort(sortConditions);
#endregion #FilterAndSortByMultipleColumns

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

sortConditions.Add(new SortCondition(2, true));
worksheet.AutoFilter.SortState.Sort(sortConditions);
#endregion #FilterSortByMultipleColumns

VB.NET

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

                sortConditions.Add(New SortCondition(2, True))
                worksheet.AutoFilter.SortState.Sort(sortConditions)
'                #End Region ' #FilterSortByMultipleColumns

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

            sortConditions.Add(New DevExpress.Spreadsheet.SortCondition(2, True))
            worksheet.AutoFilter.SortState.Sort(sortConditions)
#End Region  ' #FilterAndSortByMultipleColumns

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

                sortConditions.Add(New SortCondition(2, True))
                worksheet.AutoFilter.SortState.Sort(sortConditions)
'                #End Region ' #FilterSortByMultipleColumns