OptionsColumnFilter.PopupExcelFilterNumericValuesTabFilterType Property

Gets or sets the type of filtering UI used to create filters in the Values tab in the Excel-inspired filter dropdown (if the current column is of a numeric data type).

Namespace: DevExpress.XtraGrid.Columns

Assembly: DevExpress.XtraGrid.v18.2.dll

Declaration

C#

[DefaultValue(ExcelFilterNumericValuesTabFilterType.Default)]
[XtraSerializableProperty]
public virtual ExcelFilterNumericValuesTabFilterType PopupExcelFilterNumericValuesTabFilterType { get; set; }

VB.NET

<DefaultValue(ExcelFilterNumericValuesTabFilterType.Default)>
<XtraSerializableProperty>
Public Overridable Property PopupExcelFilterNumericValuesTabFilterType As ExcelFilterNumericValuesTabFilterType

Property Value

Type	Default	Description
DevExpress.XtraGrid.Columns.ExcelFilterNumericValuesTabFilterType	**Default**	The value that specifies the type of filtering UI in the Values tab in the Excel-inspired filter dropdown.

Property Paths

You can access this nested property as listed below:

Object Type	Path to PopupExcelFilterNumericValuesTabFilterType
GridColumn	.OptionsFilter.PopupExcelFilterNumericValuesTabFilterType
LayoutViewColumn	.OptionsFilter.PopupExcelFilterNumericValuesTabFilterType
BandedGridColumn	.OptionsFilter.PopupExcelFilterNumericValuesTabFilterType

Remarks

For numeric columns, the filtering UI in the Values tab in the Excel-inspired filter dropdown can be presented as 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

By default, the PopupExcelFilterNumericValuesTabFilterType property is set to Default. In this case, the filtering UI type is chosen based on the following logic:

Condition	Filtering UI Type
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.