Skip to main content
All docs
V24.2
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.2.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