AutoFilterColumn.ApplyFillColorFilter(Color) Method

Applies the background color filter.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void ApplyFillColorFilter(
    Color fillColor
)

VB.NET

Sub ApplyFillColorFilter(
    fillColor As Color
)

Parameters

Name	Type	Description
fillColor	Color	The background color.

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 "Products" column by background color.
AutoFilterColumn products = worksheet.AutoFilter.Columns[1];
products.ApplyFillColorFilter(worksheet["C12"].FillColor);

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 "Products" column by background color.
Dim products As AutoFilterColumn = worksheet.AutoFilter.Columns(1)
products.ApplyFillColorFilter(worksheet("C12").FillColor)