Platforms to show: All Mac Windows Linux Cross-Platform
Back to XLAutoFilterMBS class.
XLAutoFilterMBS.AddSort(columnIndex as Integer, descending as boolean) as Boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | XL | MBS XL Plugin | 21.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Used for multiple level sorting.
Returns false on error and true on success. Get error info with XLBookMBS.errorMessage.
XLAutoFilterMBS.Column(colId as Integer) as XLFilterColumnMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | XL | MBS XL Plugin | 16.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Creates it if it doesn't exist.
XLAutoFilterMBS.ColumnByIndex(colId as Integer) as XLFilterColumnMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | XL | MBS XL Plugin | 16.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
XLAutoFilterMBS.Constructor Private
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | XL | MBS XL Plugin | 16.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
XLAutoFilterMBS.GetRef(byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer) as Boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | XL | MBS XL Plugin | 16.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Returns false if error. Get error info with XLBookMBS.errorMessage.
XLAutoFilterMBS.GetSort(byref columnIndex as Integer, byref descending 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 |
Returns false if error. Get error info with XLBookMBS.errorMessage.
XLAutoFilterMBS.GetSortRange(byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer) as Boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | XL | MBS XL Plugin | 16.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Returns false if error. Get error info with XLBookMBS.errorMessage.
XLAutoFilterMBS.SetRef(rowFirst as Integer, rowLast as Integer, colFirst as Integer, colLast as Integer)
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | XL | MBS XL Plugin | 16.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Some examples using this method:
XLAutoFilterMBS.SetSort(columnIndex as Integer, descending 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 |
Returns false on error and true on success. Get error info with XLBookMBS.errorMessage.
Some examples using this method:
The items on this page are in the following plugins: MBS XL Plugin.