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: Android 4.4+, iOS 8+
Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+
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