Skip to main content
All docs
V25.1
  • Row

    Worksheet.Sort(CellRange, Color, Boolean) Method

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

    Namespace: DevExpress.Spreadsheet

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

    NuGet Package: DevExpress.Spreadsheet.Core

    Declaration

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

    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:

    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);
    
    See Also