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
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 |
|
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.