Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 12.2   12.3   12.4   12.5   13.0   13.1   13.2   13.3   13.4   13.5    Statistic    FMM    Blog  

XL.Sheet.AutoFilter.FilterType

Returns the filter type of this AutoFilter column.

Component Version macOS Windows Linux Server iOS SDK
XL 7.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Sheet.AutoFilter.FilterType"; bookRef; sheetIndex; FilterColumnIndex )   More

Parameters

Parameter Description Example
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.
$FilterColumn

Result

Returns type or error.

Description

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

This function checks for a license.

Created 1st July 2017, last changed 16th March 2020


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

💬 Ask a question or report a problem