AutoFilterSortBy Method (Int32, Boolean, IEnumerableString) |
Adds a
SortLevel to a column with the specified index (relative to the
Range) and with the specified order and custom list by which order of items to sort by.
Namespace:
GemBox.Spreadsheet
Assembly:
GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 45.0.35.1069
Syntaxpublic AutoFilter SortBy(
int columnIndex,
bool descending,
IEnumerable<string> customList
)
Public Function SortBy (
columnIndex As Integer,
descending As Boolean,
customList As IEnumerable(Of String)
) As AutoFilter
Parameters
- columnIndex
- Type: SystemInt32
The index of a column relative to the Range that an added SortLevel applies to. - descending
- Type: SystemBoolean
to sort the values in the descending order; otherwise, . - customList
- Type: System.Collections.GenericIEnumerableString
The custom list by which order of items to sort by.
Return Value
Type:
AutoFilterThis
AutoFilter to specify additional filters / sort levels or to apply filter / sort.
Exceptions
Remarks
If
FilterColumn already specifies a sort level (
Sort is not equal to
), it will be overridden.
See Also