Version

ApplyCustomFilter(CustomFilterCondition) Method

Syntax
public CustomFilter ApplyCustomFilter( 
   CustomFilterCondition condition
)

Parameters

condition
The condition which must pass for the data to be filtered in.
Exceptions
ExceptionDescription
System.ArgumentNullExceptioncondition is null.
System.InvalidOperationExceptionThe WorksheetTable.IsFilterUIVisible value of the owning table is False. Filters cannot be applied when the header row or filter button is hidden.
System.InvalidOperationExceptionIf column was removed from the table.
Remarks

Note: If the filter condition value is longer than 255 characters in length and the workbook is saved in one of the 2003 formats, the correct rows will be hidden in the saved file, but the filter will be missing from the column.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+

See Also