Skip to main content
.NET Framework 4.5.2+

FilterValue Class

A value or values used in a filter criterion.

Namespace: DevExpress.Spreadsheet

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


public class FilterValue


When you supply a variant value for a filter criteria using the AutoFilterColumn.ApplyCustomFilter, AutoFilterColumn.ApplyDynamicFilter, AutoFilterColumn.ApplyFilterCriteria or the AutoFilterColumn.ApplyTop10Filter methods, the passed values are implicitly converted to the FilterValue object.

If a value filter is applied using the corresponding end-user dialog or the AutoFilterColumn.ApplyFilterCriteria method, an array of string values corresponding to the values of filtered cells is available via the FilterValue.Values property.

If a custom filter is applied using the corresponding end-user dialog or the AutoFilterColumn.ApplyCustomFilter method, an instance of the FilterValue class is available using the CustomFilter.FirstCriteria, CustomFilter.SecondCriteria or the FilterCriteria.Filters properties.

The following code snippets (auto-collected from DevExpress Examples) contain references to the FilterValue class.


The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.


See Also