FilterColumn
Contents
[
Hide
]FilterColumn class
Represents a filter for a single column. The Filter object is a member of the Filters collection
Properties
| Name | Type | Description |
|---|---|---|
| IsDropdownVisible | boolean | Indicates whether the AutoFilter button for this column is visible. |
| Filter | Object | Gets and sets the condition of filtering data. |
| FilterType | int | Gets and sets the type fo filtering data. The value of the property is FilterType integer constant. |
| FilterValues | FilterValueCollection | |
| MultipleFilters | MultipleFilterCollection | |
| CustomFilters | CustomFilterCollection | |
| ColorFilter | ColorFilter | |
| DynamicFilter | DynamicFilter | |
| IconFilter | IconFilter | |
| Top10Filter | Top10Filter | |
| FieldIndex | int | Gets and sets the column offset in the range. |
Methods
| Name | Description |
|---|---|
| selectAll |
FilterColumn.IsDropdownVisible property
Indicates whether the AutoFilter button for this column is visible.
Type: boolean
FilterColumn.Filter property
Gets and sets the condition of filtering data.
Type: Object
FilterColumn.FilterType property
Gets and sets the type fo filtering data. The value of the property is FilterType integer constant.
Type: int
FilterColumn.FilterValues property
Type: FilterValueCollection
FilterColumn.MultipleFilters property
Type: MultipleFilterCollection
FilterColumn.CustomFilters property
Type: CustomFilterCollection
FilterColumn.ColorFilter property
Type: ColorFilter
FilterColumn.DynamicFilter property
Type: DynamicFilter
FilterColumn.IconFilter property
Type: IconFilter
FilterColumn.Top10Filter property
Type: Top10Filter
FilterColumn.FieldIndex property
Gets and sets the column offset in the range.
Type: int