AutoFilterColumn.ApplyFontColorFilter(Color) Method

Applies the font color filter.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void ApplyFontColorFilter(
    Color fontColor
)

VB.NET

Sub ApplyFontColorFilter(
    fontColor As Color
)

Parameters

Name	Type	Description
fontColor	Color	The font color used to filter cells.

Remarks

Example

C#

Worksheet worksheet = workbook.Worksheets["Regional sales"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Enable filtering for the "B2:E23" cell range.
CellRange range = worksheet["B2:E23"];
worksheet.AutoFilter.Apply(range);

// Filter values in the "Sales" column by font color.
AutoFilterColumn products = worksheet.AutoFilter.Columns[2];
products.ApplyFontColorFilter(worksheet["D10"].Font.Color);

VB.NET

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

' Enable filtering for the "B2:E23" cell range.
Dim range As CellRange = worksheet("B2:E23")
worksheet.AutoFilter.Apply(range)

' Filter values in the "Sales" column by font color.
Dim products As AutoFilterColumn = worksheet.AutoFilter.Columns(2)
products.ApplyFontColorFilter(worksheet("D10").Font.Color)