officefileapi-devexpress-dot-spreadsheet-dot-pivotfieldsortoptions.md
Gets or sets the type of sort applied to the PivotTable field.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
PivotFieldSortType Type { get; set; }
Property Type As PivotFieldSortType
| 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.
|
You can access this nested property as listed below:
| Object Type | Path to Type |
|---|---|
| PivotField |
.Sort .Type
|
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