XLFilterColumnMBS.AddFilter(Filter as String)

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	XL	MBS XL Plugin	16.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Adds the filter value.

XLFilterColumnMBS.Clear

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	XL	MBS XL Plugin	16.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Clear the filter criteria.

XLFilterColumnMBS.Constructor   Private

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	XL	MBS XL Plugin	16.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

The private constructor.

XLFilterColumnMBS.Filter(index as Integer) as String

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	XL	MBS XL Plugin	16.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Returns the filter value by index.

XLFilterColumnMBS.GetCustomFilterEx(byref Op1 as Integer, byref Value1 as String, byref Op2 as Integer, byref Value2 as String, byref andOp as Boolean) as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	XL	MBS XL Plugin	16.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Gets the custom filter criteria:

op1 - operator used by the filter comparison in the first filter criteria;
Value1 - value used in the first filter criteria;
op2 - operator used by the filter comparison in the second filter criteria;
Value12 - value used in the second filter criteria;
andOp - flag indicating whether the two criterias have an "and" relationship. True indicates "and", false indicates "or".
Returns false if error. Get error info with XLBookMBS.errorMessage.

XLFilterColumnMBS.GetTop10(byref value as Double, byref top as boolean, byref percent as boolean) as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	XL	MBS XL Plugin	16.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Gets the number of top or bottom items:

value - number of items;
top - top items if true otherwise bottom items;
percent - using percent instead of number items.
Returns false if error. Get error info with XLBookMBS.errorMessage.

XLFilterColumnMBS.SetCustomFilter(Op as Integer, Value as String)

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	XL	MBS XL Plugin	16.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Sets the custom filter criteria:

op - operator used by the filter comparison in the filter criteria;
Value - value used in the filter criteria;

Some examples using this method:

• /XL/AutoFilter Custom Filter

XLFilterColumnMBS.SetCustomFilterEx(Op1 as Integer, Value1 as String, Op2 as Integer, Value2 as String, andOp as Boolean = false)

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	XL	MBS XL Plugin	16.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Sets the custom filter criteria:

op1 - operator used by the filter comparison in the first filter criteria;
Value1 - value used in the first filter criteria;
op2 - operator used by the filter comparison in the second filter criteria;
Value2 - value used in the second filter criteria;
andOp - flag indicating whether the two criterias have an "and" relationship. True indicates "and", false indicates "or".

Some examples using this method:

• /XL/AutoFilter Number Filter

XLFilterColumnMBS.SetTop10(value as Double, top as boolean = true, percent as boolean = false)

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	XL	MBS XL Plugin	16.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Sets the number of top or bottom items:

value - number of items;
top - top items if true otherwise bottom items;
percent - using percent instead of number items.

Some examples using this method:

• /XL/AutoFilter by Top10