Lists values that specify the display mode of a column’s Drop-Down Filter.
ExcelSmart starting with v19.2.
In previous versions, DateSmart for date-time columns, and List for other columns.
A regular list of items (one item at a time can be selected).
A checked list. Multiple items can be selected/checked simultaneously.
A drop-down filter is represented by a custom template assigned to the ColumnBase.CustomColumnFilterPopupTemplate property.
This mode is equivalent to DateSmart regarding the appearance of the drop-down filter. The drop-down filter displays all the available check boxes, even if there is no data that falls into a corresponding date range.
This mode is equivalent to DateSmart, but with a different set of filters: Today, This week, This month, Next month, etc.
A built-in calendar plus check boxes to select common non-intersecting date intervals.
The available date ranges for the DateSmart and Date modes:
If there is no underlying data that would fall into a specific date range, the corresponding check box is hidden. If all values in the date-time column are set to null, all check boxes are visible.
A date-time drop-down filter without predefined values.
An Excel-style Drop-down Filter (previous).
An Excel-style Drop-down Filter (new; works starting with v18.2).
Related API Members
The following properties accept/return FilterPopupMode values:
The values listed by this enumeration are used to set the ColumnBase.FilterPopupMode property.