FilterValue Class

A value or values used in a filter criterion.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

public class FilterValue

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

See Also

FilterValue Members

DevExpress.Spreadsheet Namespace