Worksheet.Sort(CellRange, Color, Boolean) Method

Sorts the specified range by the font color in a specific order.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void Sort(
    CellRange range,
    Color fontColor,
    bool ascending
)

VB.NET

Sub Sort(
    range As CellRange,
    fontColor As Color,
    ascending As Boolean
)

Parameters

Name	Type	Description
range	CellRange	The cell range to sort.
fontColor	Color	The font color.
ascending	Boolean	true to specify ascending order; otherwise, false.

Remarks

The following code sample sorts the cell range by font color in ascending order:

C#

Worksheet worksheet = workbook.Worksheets["SortSample"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Sort the "A3:F22" range by font color in ascending order.
CellRange range = worksheet.Range["A3:F22"];
worksheet.Sort(range, worksheet["F12"].Font.Color, false);

VB.NET

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

' Sort the "A3:F22" range by font color in ascending order.
Dim range As CellRange = worksheet.Range("A3:F22")
worksheet.Sort(range, worksheet("F12").Font.Color, false)