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: 43.0.35.1020

Syntax

Copy

public 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: AutoFilter
This AutoFilter to specify additional filters / sort levels or to apply filter / sort.

Exceptions

Exception	Condition
ArgumentOutOfRangeException	columnIndex is less than zero or is equal to or greater than Width of the Range.

Remarks

If FilterColumn already specifies a sort level (Sort is not equal to ), it will be overridden.

Reference

AutoFilter Class

SortBy Overload

GemBox.Spreadsheet Namespace

AutoFilterAddLanguageSpecificTextSet("LSTEAB2234F_0?cpp=::|nu=.");SortBy Method (Int32, Boolean, IEnumerableAddLanguageSpecificTextSet("LSTEAB2234F_1?cs=&lt;|vb=(Of |cpp=&lt;|fs=&lt;'|nu=(");StringAddLanguageSpecificTextSet("LSTEAB2234F_2?cs=&gt;|vb=)|cpp=&gt;|fs=&gt;|nu=)");)

Parameters

Return Value

Reference

AutoFilterSortBy Method (Int32, Boolean, IEnumerableString)