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 |
This is an abstract class. You can't create an instance, but you can get one from various plugin functions.
- 5 properties
- property Book as XLBookMBS
- property FilterSize as Integer
- property FilterType as Integer
- property Handle as Integer
- property Index as Integer
- 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:
- XLAutoFilterMBS.Column(colId as Integer) as XLFilterColumnMBS
- XLAutoFilterMBS.ColumnByIndex(colId as Integer) as XLFilterColumnMBS
Some examples using this class:
- /XL/AutoFilter by Top10
- /XL/AutoFilter by Values
- /XL/AutoFilter Custom Filter
- /XL/AutoFilter Number Filter
Blog Entries
Release notes
- Version 18.4
- Changed properties in XLAutoFilterMBS, XLBookMBS, XLFilterColumnMBS, XLFontMBS, XLFormatMBS and XLSheetMBS class to be visible in debugger.
The items on this page are in the following plugins: MBS XL Plugin.