Skip to main content
Row

PivotFieldSortOptions.Type Property

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

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

PivotFieldSortType Type { get; set; }

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.

See Also