FilterColumn
FilterColumn class
Represents a filter for a single column.
class FilterColumn;
Properties
| Property | Type | Description |
|---|---|---|
| isDropdownVisible | boolean | Indicates whether the AutoFilter button for this column is visible. |
| filter | VObject | Gets and sets the condition of filtering data. |
| filterType | FilterType | Gets and sets the type fo filtering data. |
| multipleFilters | MultipleFilterCollection | Gets Aspose.Cells.MultipleFilterCollection for filtering data by labels or date time. |
| customFilters | CustomFilterCollection | Gets Aspose.Cells.CustomFilterCollection for filtering data by custom criteria. |
| colorFilter | ColorFilter | Readonly. Gets Aspose.Cells.ColorFilter for filtering data by color. |
| dynamicFilter | DynamicFilter | Readonly. Gets Aspose.Cells.DynamicFilter for filtering with dynamic criteria. |
| iconFilter | IconFilter | Readonly. Gets Aspose.Cells.IconFilter for filtering data by icon. |
| top10Filter | Top10Filter | Readonly. Gets Aspose.Cells.Top10Filter for filtering data by rank of data. |
| fieldIndex | number | Gets and sets the column offset in the range. |
isDropdownVisible
Indicates whether the AutoFilter button for this column is visible.
isDropdownVisible : boolean;
filter
Gets and sets the condition of filtering data.
filter : VObject;
Remarks
NOTE: This member is now obsolete. Instead,please use FilterColumn.MultipleFilters,CustomFilters and so on… property according to differnt type of filter This property will be removed 12 months later since October 2025. Aspose apologizes for any inconvenience you may have experienced.
filterType
Gets and sets the type fo filtering data.
filterType : FilterType;
multipleFilters
Gets Aspose.Cells.MultipleFilterCollection for filtering data by labels or date time.
multipleFilters : MultipleFilterCollection;
customFilters
Gets Aspose.Cells.CustomFilterCollection for filtering data by custom criteria.
customFilters : CustomFilterCollection;
colorFilter
Readonly. Gets Aspose.Cells.ColorFilter for filtering data by color.
colorFilter : ColorFilter;
dynamicFilter
Readonly. Gets Aspose.Cells.DynamicFilter for filtering with dynamic criteria.
dynamicFilter : DynamicFilter;
iconFilter
Readonly. Gets Aspose.Cells.IconFilter for filtering data by icon.
iconFilter : IconFilter;
top10Filter
Readonly. Gets Aspose.Cells.Top10Filter for filtering data by rank of data.
top10Filter : Top10Filter;
fieldIndex
Gets and sets the column offset in the range.
fieldIndex : number;