ExcelColumnFilterSettings.AllowedFilterTypes Property

Gets or sets allowed filter types.

Namespace: DevExpress.Xpf.Grid

Assembly: DevExpress.Xpf.Grid.v24.2.Core.dll

NuGet Package: DevExpress.Wpf.Grid.Core

Declaration

C#

public ExcelColumnFilterType? AllowedFilterTypes { get; set; }

VB.NET

Public Property AllowedFilterTypes As ExcelColumnFilterType?

Property Value

Type	Description
Nullable<ExcelColumnFilterType>	ExcelColumnFilterType

Available values:

Name	Description
FilterValues	The filter popup shows an Excel-like checklist with all of the available values.
FilterRules	The filter popup shows the predefined, most relevant filter conditions for the current column’s data type.

Property Paths

You can access this nested property as listed below:

Object Type	Path to AllowedFilterTypes
FilterPopupEventArgs	.ExcelColumnFilterSettings .AllowedFilterTypes

Remarks

If the AllowedFilterTypes property is set to null, the FilterValues and FilterRules tabs are allowed.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the AllowedFilterTypes property.

Note

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.

C#

wpf-data-grid-filter-columns-bound-to-collection-properties/CS/FilterDropDown_AgregateOperators/Behaviors/FilterDropDownAggregateOperatorBehavior.cs#L47

if (e.Column.FieldName == CollectionColumnFieldName) {
    e.ExcelColumnFilterSettings.AllowedFilterTypes = DevExpress.Xpf.Grid.ExcelColumnFilterType.FilterValues;
    e.ExcelColumnFilterSettings.FilterItems = ColumnItemsSource;

VB.NET

wpf-data-grid-filter-columns-bound-to-collection-properties/VB/FilterDropDown_AgregateOperators/Behaviors/FilterDropDownAggregateOperatorBehavior.vb#L60

If Equals(e.Column.FieldName, CollectionColumnFieldName) Then
    e.ExcelColumnFilterSettings.AllowedFilterTypes = ExcelColumnFilterType.FilterValues
    e.ExcelColumnFilterSettings.FilterItems = ColumnItemsSource