'Declaration Public Overloads Function ApplyCustomFilter( _ ByVal condition As CustomFilterCondition _ ) As CustomFilter
public CustomFilter ApplyCustomFilter( CustomFilterCondition condition )
Exception | Description |
---|---|
System.ArgumentNullException | condition is null. |
System.InvalidOperationException | The WorksheetTable.IsFilterUIVisible value of the owning table is False. Filters cannot be applied when the header row or filter button is hidden. |
System.InvalidOperationException | If column was removed from the table. |
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.
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
View on GitHub