Name | Value | Description | |||
exAll | 0 |
No filter applied. Use the Description
property to change the "(All)" caption in the drop down filter.
| |||
exBlanks | 1 |
Only blank items are included. Use the Description
property to change the "(Blanks)" caption in the drop down filter. The Filter
property has no effect.
| |||
exNonBlanks | 2 |
Only non blanks items are included. Use the Description
property to change the "(NonBlanks) " caption in the drop down filter.
The Filter
property has no effect.
| |||
exPattern | 3 |
Only items that match the pattern are included. The Filter
property defines the
pattern. A pattern may contain the wild card characters '?' for any single
character, '*' for zero or more occurrences of any character, '#' for any digit
character, and [chars] indicates a group of characters. If any of the *, ?, # or | characters are preceded by a \ (
escape character ) it masks the character itself. The Def(exFilterPatternTemplate)
property specifies the template for the column's filter when the Filter property or the 'Filter For' field is populated.
The exFilterDoCaseSensitive flag can be combined with exPattern or exFilter types, indicating that case-sensitive filtering should be performed.
For instance:
| |||
exDate | 4 |
Only items (of date type) within the specified range are included. The Filter
property defines the interval of dates being used to filter items.
The interval of dates should be as [dateFrom] to [dateTo]. Use the Description
property to change the "to" conjunction used to split the dates in
the interval. If the dateFrom value is missing, the control includes only the
items before the dateTo date, if the dateTo value is missing, the control
includes the items after the dateFrom date. If both dates ( dateFrom and dateTo
) are present, the control includes the items between this interval of dates.
The DisplayFilterDate property
specifies whether the drop down filter window displays a date selector to specify the interval dates to filter for.
For instance:
| |||
exNumeric | 5 |
Only items (of numeric type) within the specified range are included. The Filter
property may
include operators like <, <=, =, <>, >= or > and numbers to
define rules to include numbers in the control's list. If the FilterType property
is exNumeric, the drop down filter window doesn't display the filter list that
includes items "(All)", "(Blanks)", ... and so on.
For instance:
| |||
exCheck | 6 |
Only checked or unchecked items are included. The CellState
property indicates the state of the cell's checkbox. The Filter
property on "0" filters for unchecked items, while "1"
filters for checked items. A checked item has the the CellState property
different than zero. An unchecked item has the CellState property on zero.
For instance:
| |||
exImage | 10 |
Only items showing the specified icons (icon index) are included. The CellImage property
indicates the cell's icon. Multiple icons are separated by the '|' character.
The Filter property defines the list of icons, separated by the '|' character, to apply the filter.
For instance:
| |||
exFilter | 240 |
Only the items that are in the Filter property are included.
Multiple items are separated by the '|' character.
The
exShowCheckBox flag of FilterList property displays a check box for each included
item. The exFilterDoCaseSensitive flag can be combined with exPattern or exFilter types, indicating that case-sensitive filtering should be performed.
For instance:
| |||
exFilterDoCaseSensitive | 256 | If this flag is present, the column filtering is case-sensitive. If this flag is missing, the filtering is case-insensitive by default. The exFilterDoCaseSensitive flag can be used to enable case-sensitive filtering within the column. However, this flag is not applied to the filter prompt feature. The exFilterDoCaseSensitive flag can be combined with exPattern or exFilter types. | |||
exFilterExclude | 512 |
The flag indicates that the Exclude field of the column is checked, meaning items that match the filter are excluded from the list.
The
exShowExclude flag of FilterList property indicates whether the Exclude option is shown in the drop down filter
window.
|