Platforms to show: All Mac Windows Linux Cross-Platform
XLAutoFilterMBS 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.
- 3 properties
- property Book as XLBookMBS
- property ColumnSize as Integer
- property Handle as Integer
- 9 methods
- method AddSort(columnIndex as Integer, descending as boolean) as Boolean
- method Column(colId as Integer) as XLFilterColumnMBS
- method ColumnByIndex(colId as Integer) as XLFilterColumnMBS
- method Constructor Private
- method GetRef(byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer) as Boolean
- method GetSort(byref columnIndex as Integer, byref descending as Boolean) as Boolean
- method GetSortRange(byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer) as Boolean
- method SetRef(rowFirst as Integer, rowLast as Integer, colFirst as Integer, colLast as Integer)
- method SetSort(columnIndex as Integer, descending as Boolean) as Boolean
This class has no sub classes.
Some properties using for this class:
- XLSheetMBS.AutoFilter as XLAutoFilterMBS
Some examples using this class:
- /XL/AutoFilter by Top10
- /XL/AutoFilter by Values
- /XL/AutoFilter Custom Filter
- /XL/AutoFilter Number Filter
- /XL/AutoFilter Sort
Blog Entries
- News from the MBS Xojo Plugins in version 21.5
- MBS Xojo Plugins, version 21.5pr1
- LibXL Extras for Xojo
- MBS Xojo Plugins, version 18.4pr9
Release notes
- Version 21.5
- Added AddSort method to XLAutoFilterMBS class.
- 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.