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.2.dll
#Declaration
[DefaultValue(ExcelFilterTextFilters.Default)]
[XtraSerializableProperty]
public virtual ExcelFilterTextFilters PopupExcelFilterTextFilters { get; set; }
#Property Value
Type | Default | Description |
---|---|---|
DevExpress. |
Default | All |
#Property Paths
You can access this nested property as listed below:
Object Type | Path to Popup |
---|---|
Grid |
|
#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.