Worksheet.Sort(Range, Int32) Method

Sorts the specified range by the specified column in ascending order.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

void Sort(
    Range range,
    int columnOffset
)

VB.NET

Sub Sort(
    range As Range,
    columnOffset As Integer
)

Parameters

Name	Type	Description
range	Range	A Range object that is the range of cells in a worksheet.
columnOffset	Int32	An integer that is the offset of the column by which to sort from the first column in the range. The first column has the offset 0.

Remarks

Cell data are sorted using default built-in comparer. Text values are sorted depending on the current culture, numbers are sorted smallest to largest, dates and times are sorted oldest to newest.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Sort(Range, Int32) 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/SortActions.cs#L67

Range range = worksheet.Range["A3:F22"];
worksheet.Sort(range, 3);

wpf-spreadsheetcontrol-api-part-2-e4944/CS/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/SortActions.cs#L104

Range range = worksheet.Range["A3:F22"];
worksheet.Sort(range, 3);

winforms-spreadsheetcontrol-api-part-2-e4832/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/SortActions.cs#L98

Range range = worksheet.Range["A3:F22"];
worksheet.Sort(range, 3);

VB.NET

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/CodeExamples/SortActions.vb#L66

Dim range As Range = worksheet.Range("A3:F22")
worksheet.Sort(range, 3)

wpf-spreadsheetcontrol-api-part-2-e4944/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/SortActions.vb#L102

Dim range As Range = worksheet.Range("A3:F22")
worksheet.Sort(range, 3)

winforms-spreadsheetcontrol-api-part-2-e4832/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/SortActions.vb#L101

Dim range As Range = worksheet.Range("A3:F22")
worksheet.Sort(range, 3)