Topics
All
Mac OS X
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server (Not)
Client
Old
Guides
Examples
New in version:
6.5
7.0
7.1
7.2
7.3
7.4
7.5
8.0
8.1
8.2
Statistic
XL.Sheet.AutoFilter.GetSort
Gets the zero-based index of sorted column in AutoFilter and its sort order.
Component | Version | macOS | Windows | Server | FileMaker Cloud | FileMaker iOS SDK |
XL | 7.2 | Yes | Yes | Yes | Yes | Yes |
MBS( "XL.Sheet.AutoFilter.GetSort"; bookRef; sheetIndex; Selector )
Parameters
Parameter | Description | Example value |
---|---|---|
bookRef | The reference to the workbook. Please use XL.LoadBook to load a file. | $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" |
Result
Returns OK or error.
Description
Gets the zero-based index of sorted column in AutoFilter and its sort order.See also
- XL.Book.SheetCount
- XL.LoadBook
- XL.Sheet.AutoFilter.AddFilter
- XL.Sheet.AutoFilter.Clear
- XL.Sheet.AutoFilter.Filter
- XL.Sheet.AutoFilter.FilterSize
- XL.Sheet.AutoFilter.GetRef
- XL.Sheet.AutoFilter.GetSortRange
- XL.Sheet.AutoFilter.GetTop10
- XL.Sheet.AutoFilter.SetRef
- XL.Sheet.AutoFilter.SetSort
- XL.Sheet.AutoFilter.SetTop10
XL.Sheet.AutoFilter.GetRef - XL.Sheet.AutoFilter.GetSortRange
Feedback: Report problem or ask question.
Links
MBS Xojo Chart Plugins