Filters are not constantly evaluated as data within the table changes. Filters are applied to the table only when they are added or removed on a column in the table or when the WorksheetTable.ReapplyFilters method is called.
Note: When the filters are reevaluated, the rows of any cells which don't meet the filter criteria of their column will be hidden. When a row is filtered out, the entire row is hidden from the worksheet, so any data outside the table but in the same row will also be hidden.
Target Platforms: Windows 8.1, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
WorksheetTableColumn Class
WorksheetTableColumn Members
ApplyAverageFilter Method
ApplyCustomFilter(CustomFilterCondition) Method
ApplyCustomFilter(CustomFilterCondition,CustomFilterCondition,ConditionalOperator) Method
ApplyDatePeriodFilter Method
ApplyFontColorFilter(Color) Method
ApplyFontColorFilter(WorkbookColorInfo) Method
ApplyFixedValuesFilter(Boolean,String[]) Method
ApplyFixedValuesFilter(Boolean,IEnumerable<String>) Method
ApplyFixedValuesFilter(Boolean,IEnumerable<FixedDateGroup>) Method
ApplyFixedValuesFilter(Boolean,CalendarType,IEnumerable<FixedDateGroup>) Method
ApplyRelativeDateRangeFilter Method
ApplyTopOrBottomFilter Method
ApplyTopOrBottomFilter(TopOrBottomFilterType,Int32) Method
ApplyYearToDateFilter Method
ClearFilter Method
ClearFilters Method
ReapplyFilters Method
View on GitHub