.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

AutoFilterColumn.ApplyFilterCriteria(FilterValue, IList<DateGrouping>) Method

Filters data by cell values and DateTime values.

Namespace: DevExpress.Spreadsheet

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


void ApplyFilterCriteria(
    FilterValue filters,
    IList<DateGrouping> dateGroupings


Name Type Description
filters FilterValue

A FilterValue object containing values to be used in a filter.

dateGroupings IList<DateGrouping>

A list of DateGrouping items.


Use the ApplyFilterCriteria method to filter a column that contains data of different types (for example, text and dates), as illustrated in the example below.

' Enable filtering for the specified cell range.
Dim range As CellRange = worksheet("B2:E23")
' Create date grouping item to filter January 2015 dates.
Dim groupings As IList(Of DateGrouping) = New List(Of DateGrouping)()
Dim dateGroupingJan2015 As New DateGrouping(New Date(2015, 1, 1), DateTimeGroupingType.Month)

' Filter the data in the "Reported Date" column to display values reported in January 2015.
worksheet.AutoFilter.Columns(3).ApplyFilterCriteria("gennaio 2015", groupings)
See Also