OptionsColumnFilter.PopupExcelFilterTextFilters Property
Gets or sets whether to show pattern-matching (e.g., Is Like) and relational (e.g., Greater Than) operators for string values in the Excel style pop-up filter menus.
Namespace: DevExpress.XtraGrid.Columns
Assembly: DevExpress.XtraGrid.v24.1.dll
NuGet Packages: DevExpress.Win.Grid, DevExpress.Win.Navigation
Declaration
[DefaultValue(ExcelFilterTextFilters.Default)]
[XtraSerializableProperty]
public virtual ExcelFilterTextFilters PopupExcelFilterTextFilters { get; set; }Property Value
| Type | Default | Description |
|---|---|---|
| DevExpress.XtraGrid.Columns.ExcelFilterTextFilters | Default | AllFilters, to show relational and pattern-matching operators in the Excel style pop-up filter menus; otherwise, TextFilters or Default. |
Property Paths
You can access this nested property as listed below:
| Object Type | Path to PopupExcelFilterTextFilters |
|---|---|
| GridColumn |
|
Remarks
The PopupExcelFilterTextFilters property specifies filters and operators the Excel style pop-up filter menus contain.
- TextFilters or Default — the menus contain only operators and filters for text values (Equals, Does Not Equal, Begins With, Ends With, Contains, Does Not Contain, Is Blank, Is Not Blank, Custom Filter);
- AllFilters — the menus also contain pattern-matching (Is Like, Is Not Like) and relational (Greater Than, Greater Than Or Equal To, Less Than, Less Than Or Equal To, Between) operators.
The ColumnView.ShowFilterPopupExcel event allows you to also specify the FilterPopupExcelEventArgs.ShowLikeFilters and FilterPopupExcelEventArgs.ShowComparisons arguments to show/hide the pattern-matching and relational operators.