Specifies whether filtering from the host application is applied when the data is retrieved.
|Hosts:||Excel, Project, Word|
|Last changed in||1.1|
|Office.FilterType.All||"all"||Return all data (not filtered by the host application).|
|Office.FilterType.OnlyVisible||"onlyVisible"||Return only the visible data (as filtered by the host application).|
A capital Y in the following matrix indicates that this enumeration is supported in the corresponding Office host application. An empty cell indicates that the Office host application doesn't support this enumeration.
For more information about Office host application and server requirements, see Requirements for running Office Add-ins.
Supported hosts, by platform
|Office for Windows desktop||Office Online (in browser)||Office for iPad|
|Add-in types||Content, task pane|
|1.1||Added support for Excel and Word in Office for iPad.|