PivotFieldSortOptions.Type Property

Gets or sets the type of sort applied to the PivotTable field.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

PivotFieldSortType Type { get; set; }

VB.NET

Property Type As PivotFieldSortType

Property Value

Type	Description
PivotFieldSortType	One of the PivotFieldSortType enumeration values specifying the sort order.

Available values:

Name	Description
Ascending	Sorts the field in ascending order.
Descending	Sorts the field in descending order.
Manual	Enables manual sorting of field items by dragging them in the UI. Currently, the SpreadsheetControl doesn’t support manual sorting of field items.

Property Paths

You can access this nested property as listed below:

Object Type	Path to Type
PivotField	.Sort.Type

Remarks

Use the Type property to obtain or modify the type of sort applied to the specified pivot field.

If you wish to sort items in a specific field in ascending or descending order, use the PivotField.SortType property. To sort a row or column field based on values in a data field, use the PivotField.SortItems method.