Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

XL.Sheet.AutoFilter.GetSortEx

Gets the zero-based index of sorted column in AutoFilter and its sort order.

Component Version macOS Windows Linux Server iOS SDK
XL 16.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Sheet.AutoFilter.GetSortEx"; BookRef; SheetIndex; Selector { ; Level } )   More

Parameters

Parameter Description Example Flags
BookRef The reference number for the workbook. $ref
SheetIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0
Selector Which value to return.
Can be columnIndex or descending.		 "columnIndex"
Level The sort level to query.
Default is 0.		 0 Optional

Result

Returns number or error.

Description

Gets the zero-based index of sorted column in AutoFilter and its sort order.

See also

Release notes

  • Version 16.3
    • Added XL.Sheet.AutoFilter.GetSortEx and XL.Sheet.AutoFilter.SortLevels functions.

This function checks for a license.

Created 21st May 2026, last changed 21st May 2026


XL.Sheet.AutoFilter.GetSort - XL.Sheet.AutoFilter.GetSortRange


MarkDown version: XLSheetAutoFilterGetSortEx.md