Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.4   6.5   7.0   7.1   7.2   7.3   7.4   7.5   8.0   8.1    Statistic  


Returns the filter type of this AutoFilter column.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
XL 7.3 Yes Yes Yes Yes Yes

MBS( "XL.Sheet.AutoFilter.FilterType"; bookRef; sheetIndex; FilterColumnIndex )


Parameter Description Example value
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
sheetIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0
FilterColumnIndex The column index of the filter.
Range from 0 to XL.Sheet.AutoFilter.ColumnSize-1.


Returns OK or error.


Returns the filter type of this AutoFilter column.
Filter valueDescription
ValueFilter by specified values.
Top10The top N (percent or number of items) to filter by.
CustomCustom filter with specified criteria.
DynamicSpecifies dynamic filter criteria.
ColorSpecifies the color to filter by.
IconSpecifies the icon to filter by.
ExtDefines flexible storage extensions.
Not setNo filter.

See also

XL.Sheet.AutoFilter.FilterSize   -   XL.Sheet.AutoFilter.GetCustomFilter

Feedback: Report problem or ask question.

MBS FileMaker blog