officefileapi-devexpress-dot-spreadsheet-dot-sortfield.md
Gets or sets the comparer used to sort the column.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public IComparer<CellValue> Comparer { get; set; }
Public Property Comparer As IComparer(Of CellValue)
| Type | Description |
|---|---|
| IComparer<CellValue> |
A IComparer<T><CellValue,> object used to compare cell values in a column.
|
You can use default built-in comparers - the Worksheet.Comparers.Ascending for sorting in ascending order and the Worksheet.Comparers.Descending for sorting in descending order, or implement a custom comparer.
For an example of a custom comparer, see the Worksheet.Sort method.
The following code snippets (auto-collected from DevExpress Examples) contain references to the Comparer property.
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.
sortField1.ColumnOffset = 0;
sortField1.Comparer = worksheet.Comparers.Ascending;
fields.Add(sortField1);
sortField1.ColumnOffset = 0;
sortField1.Comparer = worksheet.Comparers.Ascending;
fields.Add(sortField1);
sortField1.ColumnOffset = 0;
sortField1.Comparer = worksheet.Comparers.Ascending;
fields.Add(sortField1);
sortField1.ColumnOffset = 0
sortField1.Comparer = worksheet.Comparers.Ascending
fields.Add(sortField1)
sortField1.ColumnOffset = 0
sortField1.Comparer = worksheet.Comparers.Ascending
fields.Add(sortField1)
sortField1.ColumnOffset = 0
sortField1.Comparer = worksheet.Comparers.Ascending
fields.Add(sortField1)
See Also