TreeListOptionsColumnFilter.PopupExcelFilterNumericValuesTabFilterType Property

Gets or sets whether numeric values are arranged in a list or a range in the Excel style pop-up filter menus.

Namespace: DevExpress.XtraTreeList.Columns

Assembly: DevExpress.XtraTreeList.v23.2.dll

NuGet Packages: DevExpress.Win.Navigation, DevExpress.Win.TreeList

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.XtraTreeList.ExcelFilterNumericValuesTabFilterType	Default	An DevExpress.XtraTreeList.ExcelFilterNumericValuesTabFilterType enumeration value that specifies whether numeric values are arranged in a list or a range in the Excel style pop-up filter menus.

Property Paths

You can access this nested property as listed below:

Object Type	Path to PopupExcelFilterNumericValuesTabFilterType
TreeListColumn	.OptionsFilter .PopupExcelFilterNumericValuesTabFilterType

Remarks

Set the PopupExcelFilterNumericValuesTabFilterType property to Range or List to specify whether numeric values are arranged in a range or a list in the Excel style pop-up filter menus.

If the PopupExcelFilterNumericValuesTabFilterType property is set to Default, the UI type is chosen based on the following logic.

Condition	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 TreeListColumn.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.