GrapeCity.Documents.Excel.ValueSortField.-ctor

ValueSortField Constructor

ValueSortField(IRange, SortOrder)

Creates a value sort field for the specified key range and sort order.

Declaration

public ValueSortField(IRange key, SortOrder order = SortOrder.Ascending)

Public Sub New(key As IRange, Optional order As SortOrder = SortOrder.Ascending)

Parameters

Type	Name	Description
IRange	key	The range that provides the values used as the sort key. Must not be `null`.
SortOrder	order	The sort order to apply to the key range. Defaults to Ascending when omitted.

ValueSortField(IRange, string)

Creates a value sort field that uses a custom sort list.

Use this constructor to sort by a user-defined value sequence instead of the normal ascending or descending order. The custom list string can contain values such as 3,2,5,1 or quoted text entries such as "\"High\", \"Medium\", \"Low\"".

Declaration

public ValueSortField(IRange key, string customValues)

Public Sub New(key As IRange, customValues As String)

Parameters

Type	Name	Description
IRange	key	The range that provides the sort key.
string	customValues	The custom list string that defines the sort order.