Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotFieldSortOptions.Type Property

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.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