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.v23.2.dll
NuGet Packages: DevExpress.Win.Grid, DevExpress.Win.Navigation
Declaration
[DefaultValue(ExcelFilterNumericValuesTabFilterType.Default)]
[XtraSerializableProperty]
public virtual ExcelFilterNumericValuesTabFilterType PopupExcelFilterNumericValuesTabFilterType { get; set; }
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 |
|
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.