wpf-devexpress-dot-xpf-dot-grid-dot-excelcolumnfiltersettings-3f19fd25.md
Gets or sets allowed filter types.
Namespace : DevExpress.Xpf.Grid
Assembly : DevExpress.Xpf.Grid.v25.2.Core.dll
NuGet Package : DevExpress.Wpf.Grid.Core
public ExcelColumnFilterType? AllowedFilterTypes { get; set; }
Public Property AllowedFilterTypes As ExcelColumnFilterType?
| Type | Description |
|---|---|
| Nullable<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.
|
You can access this nested property as listed below:
| Object Type | Path to AllowedFilterTypes |
|---|---|
| FilterPopupEventArgs |
.ExcelColumnFilterSettings .AllowedFilterTypes
|
If the AllowedFilterTypes property is set to null , the FilterValues and FilterRules tabs are allowed.
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.
if (e.Column.FieldName == CollectionColumnFieldName) {
e.ExcelColumnFilterSettings.AllowedFilterTypes = DevExpress.Xpf.Grid.ExcelColumnFilterType.FilterValues;
e.ExcelColumnFilterSettings.FilterItems = ColumnItemsSource;
If Equals(e.Column.FieldName, CollectionColumnFieldName) Then
e.ExcelColumnFilterSettings.AllowedFilterTypes = ExcelColumnFilterType.FilterValues
e.ExcelColumnFilterSettings.FilterItems = ColumnItemsSource
See Also
ExcelColumnFilterSettings Class