FilterValue Class

A value or values used in a filter criterion.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

public class FilterValue

VB.NET

Public Class FilterValue

Related API Members

The following members return FilterValue objects:

• CustomFilter.FirstCriteria
• CustomFilter.SecondCriteria
• FilterCriteria.Filters
• FilterValue.FilterByBlank
• FilterValue.FromDateTime(DateTime, Boolean)
• PivotFilter.SecondValue
• PivotFilter.Value

Remarks

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.

Inheritance

Object

FilterValue