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: 9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5   10.6    Statistic    FMM    Blog  

XL.Sheet.AutoFilter.SetCustomFilter

Sets the custom filter criteria.

Component Version macOS Windows Linux Server FileMaker iOS SDK
XL 7.3 Yes Yes Yes Yes Yes
MBS( "XL.Sheet.AutoFilter.SetCustomFilter"; bookRef; sheetIndex; FilterColumnIndex; Operator1; Value1 { ; Operator2; Value2; AndOperator } )   More

Parameters

Parameter Description Example Flags
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
Operator1 The operator used by the filter comparison in the first filter criteria.
Can be =, ≠, <, ≤, > or ≥		 "="
Value1 value used in the first filter criteria 10
Operator2 The operator used by the filter comparison in the second filter criteria.
Can be =, ≠, <, ≤, > or ≥		 "=" Optional
Value2 The value used in the second filter criteria. "20" Optional
AndOperator Flag indicating whether the two criterias have an "and" relationship.
Pass "And" or "Or".		 "And" Optional

Result

Returns OK or error.

Description

Sets the custom filter criteria.
Operator1: operator used by the filter comparison in the first filter criteria;
Value1: value used in the first filter criteria;
Operator2: operator used by the filter comparison in the second filter criteria;
Value2: value used in the second filter criteria;
AndOperator: Flag indicating whether the two criteria have an "and" relationship.

See also

Created 1st July 2017, last changed 1st July 2017


XL.Sheet.AutoFilter.GetTop10   -   XL.Sheet.AutoFilter.SetRef

Feedback: Report problem or ask question.



Links
MBS Xojo Chart Plugins

Start Chat