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) Method

Sorts the specified range by the specified font color in ascending order.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

void Sort(
    CellRange range,
    Color fontColor
)

#Parameters

Name Type Description
range CellRange

The range of worksheet cells.

fontColor Color

The font color.

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