windowsforms-devexpress-dot-xtragrid-dot-columns-dot-optionscolumnfilter-0b34a9bd.md
Gets or sets the type of UI displayed in the Values tab of the Excel-inspired filter dropdown (if the current column is of a numeric data type).
Namespace : DevExpress.XtraGrid.Columns
Assembly : DevExpress.XtraGrid.v25.2.dll
NuGet Packages : DevExpress.Win.Grid, DevExpress.Win.Navigation
[DefaultValue(ExcelFilterNumericValuesTabFilterType.Default)]
[XtraSerializableProperty]
public virtual ExcelFilterNumericValuesTabFilterType PopupExcelFilterNumericValuesTabFilterType { get; set; }
<DefaultValue(ExcelFilterNumericValuesTabFilterType.Default)>
<XtraSerializableProperty>
Public Overridable Property PopupExcelFilterNumericValuesTabFilterType As ExcelFilterNumericValuesTabFilterType
| Type | Default | Description |
|---|---|---|
| DevExpress.XtraGrid.Columns.ExcelFilterNumericValuesTabFilterType | Default |
The value that specifies the type of UI in the Values tab of the Excel-inspired filter dropdown.
|
You can access this nested property as listed below:
| Object Type | Path to PopupExcelFilterNumericValuesTabFilterType |
|---|---|
| GridColumn |
.OptionsFilter .PopupExcelFilterNumericValuesTabFilterType
|
For numeric columns, the Values tab in the Excel-inspired filter dropdown can display a list or as a range track bar. You can set the PopupExcelFilterNumericValuesTabFilterType property to List or Range to explicitly apply corresponding display mode:
| List | Range |
|---|---|
If PopupExcelFilterNumericValuesTabFilterType is set to Default , the filter control type depends on the following conditions:
| Condition | Filter Control |
|---|---|
| The column’s in-place editor is one of the following: ImageComboBox (RepositoryItemImageComboBox), RadioGroup (RepositoryItemRadioGroup), PopupContainerEdit (RepositoryItemPopupContainerEdit), or LookUpEdit (RepositoryItemLookUpEditBase descendants). | List |
| The column’s GridColumn.FilterMode property is set to DisplayText. | List |
| The column’s bound field is marked with the KeyAttribute (e.g., System.ComponentModel.DataAnnotations.KeyAttribute ). | List |
| The column’s bound field ends with “id” (case-insensitive comparison) and is of the int, uint, long, ulong, GUID or IntPtr data type. | List |
| The column’s bound field is marked with the DevExpress.Utils.Filtering.FilterLookup attribute. | List |
| The column’s bound field is marked with the DevExpress.Utils.Filtering.FilterRange attribute | Range |
To learn more about the DevExpress.Utils.Filtering.FilterLookup and DevExpress.Utils.Filtering.FilterRange attributes, see Filtering Attributes.
See Also