Platforms to show: All Mac Windows Linux Cross-Platform

XLFilterColumnMBS class

Type Topic Plugin Version macOS Windows Linux iOS Targets
class XL MBS XL Plugin 16.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The class for filter column.

This is an abstract class. You can't create an instance, but you can get one from various plugin functions.

  • 5 properties
  • 9 methods
    • method AddFilter(Filter as String)
    • method Clear
    • method Constructor   Private
    • method Filter(index as Integer) as String
    • method GetCustomFilterEx(byref Op1 as Integer, byref Value1 as String, byref Op2 as Integer, byref Value2 as String, byref andOp as Boolean) as boolean
    • method GetTop10(byref value as Double, byref top as boolean, byref percent as boolean) as boolean
    • method SetCustomFilter(Op as Integer, Value as String)
    • method SetCustomFilterEx(Op1 as Integer, Value1 as String, Op2 as Integer, Value2 as String, andOp as Boolean = false)
    • method SetTop10(value as Double, top as boolean = true, percent as boolean = false)
  • 14 constants

Filter Types

Constant Value Description
FilterColor 4 Specifies the color to filter by.
FilterCustom 2 Custom filter with specified criteria.
FilterDynamic 3 Specifies dynamic filter criteria.
FilterExt 6 Defines flexible storage extensions.
FilterIcon 5 Specifies the icon to filter by.
FilterNotSet 7 No filter.
FilterTop10 1 The top N (percent or number of items) to filter by.
FilterValue 0 Filter by specified values.

Compare Operators

Constant Value Description
OperatorEqual 0 Equal
OperatorGreaterThan 1 Greater than
OperatorGreaterThanOrEqual 2 Greater than or equal
OperatorLessThan 3 Less than
OperatorLessThanOrEqual 4 Less than or equal
OperatorNotEqual 5 Not equal

This class has no sub classes.

Some methods using this class:

Some examples using this class:

Blog Entries

Release notes


The items on this page are in the following plugins: MBS XL Plugin.


XLCopyOptionsMBS   -   XLFontMBS


The biggest plugin in space...