PivotFieldSortType Enum

Lists values that specify the sort order for a PivotTable field.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.2.Core.dll

Declaration

C#

public enum PivotFieldSortType

VB.NET

Public Enum PivotFieldSortType

Members

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.

Related API Members

The following properties accept/return PivotFieldSortType values:

• PivotField.SortType
• PivotFieldSortOptions.Type

Remarks

The values listed by this enumeration are used by the PivotField.SortType property and PivotField.SortItems method to sort items in a PivotTable field.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the PivotFieldSortType enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

wpf-spreadsheet-pivot-table-api-t314425/CS/SpreadsheetWPFPivotTableExamples/CodeExamples/PivotFieldActions.cs#L112

// Sort items in the "Product" field.
field.SortType = PivotFieldSortType.Ascending;
#endregion #SortFieldItems

winforms-spreadsheet-pivot-table-api-t298650/CS/SpreadsheetPivotTableExamples/CodeExamples/PivotFieldActions.cs#L111

// Sort items in the "Product" field.
field.SortType = PivotFieldSortType.Ascending;
#endregion #SortFieldItems

spreadsheet-pivot-table-api-examples-t501894/CS/SpreadsheetDocServerPivotAPI/CodeExamples/PivotFieldActions.cs#L111

// Sort items in the "Product" field.
field.SortType = PivotFieldSortType.Ascending;
#endregion #SortFieldItems

VB.NET

wpf-spreadsheet-pivot-table-api-t314425/VB/SpreadsheetWPFPivotTableExamples/CodeExamples/PivotFieldActions.vb#L107

            ' Sort items in the "Product" field.
            field.SortType = PivotFieldSortType.Ascending
'            #End Region ' #SortFieldItems

winforms-spreadsheet-pivot-table-api-t298650/VB/SpreadsheetPivotTableExamples/CodeExamples/PivotFieldActions.vb#L106

            ' Sort items in the "Product" field.
            field.SortType = PivotFieldSortType.Ascending
'            #End Region ' #SortFieldItems

spreadsheet-pivot-table-api-examples-t501894/VB/SpreadsheetDocServerPivotAPI/CodeExamples/PivotFieldActions.vb#L106

            ' Sort items in the "Product" field.
            field.SortType = PivotFieldSortType.Ascending
'            #End Region ' #SortFieldItems