AutoFilterColumn.ApplyFillFilter(Fill) Method

Applies a filter by cell fill pattern.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void ApplyFillFilter(
    Fill fill
)

VB.NET

Sub ApplyFillFilter(
    fill As Fill
)

Parameters

Name	Type	Description
fill	Fill	An object that contains fill parameters.

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 fill color.
AutoFilterColumn products = worksheet.AutoFilter.Columns[1];
products.ApplyFillFilter(worksheet["C10"].Fill);

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 fill color.
Dim products As AutoFilterColumn = worksheet.AutoFilter.Columns(1)
products.ApplyFillFilter(worksheet("C10").Fill)