Monkeybread Software - MBS FileMaker Plugin: XL.Sheet.IsAutoFilter

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: 11.4 11.5 12.0 12.1 12.2 12.3 12.4 12.5 13.0 13.1 Statistic FMM Blog

XL.Sheet.IsAutoFilter

Whether this sheet has an auto filter.

Component	Version	macOS	Windows	Linux	Server	iOS SDK
XL	11.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes

MBS( "XL.Sheet.IsAutoFilter"; bookRef; sheetIndex ) 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

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

Result

Returns 1, 0 or error.

Description

Whether this sheet has an auto filter.
Returns 1 if there is an auto filter or 0 if not.

Release notes

Version 11.5
- Added XL.Sheet.AutoFilter.AddSort and XL.Sheet.IsAutoFilter functions.

Blog Entries

This function checks for a paid license.

Created 23th September 2021, last changed 23th September 2021

XL.Sheet.InsertRow - XL.Sheet.Merge