-
Spread Windows Forms Product Documentation
- Getting Started
-
Developer's Guide
- Understanding the Product
- Working with the Component
- Spreadsheet Objects
- Ribbon Control
- Sheets
- Rows and Columns
- Headers
- Cells
- Cell Types
- Data Binding
- Customizing the Sheet Appearance
- Customizing Interaction in Cells
- Tables
- Pivot Table
- Understanding the Underlying Models
- Customizing Row or Column Interaction
- Formulas in Cells
- Sparklines
- Keyboard Interaction
- Events from User Actions
- File Operations
- Storing Excel Summary and View
- Printing
- Chart Control
- Enhanced Chart
- Customizing Drawing
- Touch Support with the Component
- Spread Designer Guide
- Assembly Reference
- Import and Export Reference
- Version Comparison Reference
Sorting Pivot Table Fields
Spread WinForms provides the AutoSortOrder property, which allows you to sort fields in a pivot table in either ascending or descending order.
Additionally, you can use the AutoSortField property to specify or retrieve the name of the data field used for sorting.
Refer to the following example code to sort Category field in a pivot table.
C#
fpSpread1.BorderCollapse = BorderCollapse.Enhanced;
IWorkbook workbook = fpSpread1.AsWorkbook();
IWorksheet sheet1 = workbook.ActiveSheet;
// Set data.
sheet1.SetValue(0, 0, new object[,] {
{"OrderDate", "Region", "City", "Category", "Product", "Quantity"},
{"2025-07-01", "East", "Jersey", "Breads", "Bakery", 1120},
{"2025-07-01", "East", "Jersey", "Breads", "Cookie", 563},
{"2025-07-02", "East", "Washington, DC", "Breads", "Bakery", 1281},
{"2025-07-02", "East", "Washington, DC", "Breads", "Cookie", 546},
{"2025-07-01", "East", "Jersey", "Beverages", "Coffee", 326},
{"2025-07-02", "East", "Washington, DC", "Beverages", "Coffee", 205},
{"2025-07-02", "East", "Washington, DC", "Beverages", "Juice", 186},
{"2025-07-01", "West", "San Francisco", "Breads", "Bakery", 1262},
{"2025-07-01", "West", "San Francisco", "Breads", "Cookie", 349},
{"2025-07-01", "West", "Seattle", "Breads", "Bakery", 524},
{"2025-07-01", "West", "Seattle", "Breads", "Cookie", 196},
{"2025-07-01", "West", "San Francisco", "Beverages", "Coffee", 363},
{"2025-07-01", "West", "Seattle", "Beverages", "Coffee", 100},
{"2025-07-02", "East", "Jersey", "Beverages", "Juice", 120},
{"2025-07-02", "West", "San Francisco", "Breads", "Bakery", 350},
{"2025-07-02", "West", "Seattle", "Beverages", "Tea", 180},
{"2025-07-02", "East", "Jersey", "Breads", "Cookie", 75},
{"2025-07-03", "West", "San Francisco", "Beverages", "Juice", 210},
{"2025-07-03", "East", "Boston", "Breads", "Bakery", 420}
});
IPivotCache pvCache = fpSpread1.AsWorkbook().PivotCaches.Create("Sheet1!A1:F20");
// Configure pivot table's fields.
IPivotTable pvTable = pvCache.CreatePivotTable(sheet1.Cells["I1"]);
IPivotFields pvFields = pvTable.PivotFields;
pvTable.AddDataField(pvFields["Quantity"], "Sum of quantity", ConsolidationFunction.Sum);
pvFields["Region"].Orientation = PivotFieldOrientation.Row;
pvFields["City"].Orientation = PivotFieldOrientation.Row;
pvFields["Category"].Orientation = PivotFieldOrientation.Column;
pvFields["Product"].Orientation = PivotFieldOrientation.Column;
pvFields["OrderDate"].Orientation = PivotFieldOrientation.Page;
// Set the sort order of the "Category" field to ascending.
pvFields["Category"].AutoSortOrder=FieldSortType.Ascending;VB
fpSpread1.BorderCollapse = BorderCollapse.Enhanced
Dim workbook As IWorkbook = fpSpread1.AsWorkbook()
Dim sheet1 As IWorksheet = workbook.ActiveSheet
' Set data.
sheet1.SetValue(0, 0, New Object(,) {
{"OrderDate", "Region", "City", "Category", "Product", "Quantity"},
{"2025-07-01", "East", "Jersey", "Breads", "Bakery", 1120},
{"2025-07-01", "East", "Jersey", "Breads", "Cookie", 563},
{"2025-07-02", "East", "Washington, DC", "Breads", "Bakery", 1281},
{"2025-07-02", "East", "Washington, DC", "Breads", "Cookie", 546},
{"2025-07-01", "East", "Jersey", "Beverages", "Coffee", 326},
{"2025-07-02", "East", "Washington, DC", "Beverages", "Coffee", 205},
{"2025-07-02", "East", "Washington, DC", "Beverages", "Juice", 186},
{"2025-07-01", "West", "San Francisco", "Breads", "Bakery", 1262},
{"2025-07-01", "West", "San Francisco", "Breads", "Cookie", 349},
{"2025-07-01", "West", "Seattle", "Breads", "Bakery", 524},
{"2025-07-01", "West", "Seattle", "Breads", "Cookie", 196},
{"2025-07-01", "West", "San Francisco", "Beverages", "Coffee", 363},
{"2025-07-01", "West", "Seattle", "Beverages", "Coffee", 100},
{"2025-07-02", "East", "Jersey", "Beverages", "Juice", 120},
{"2025-07-02", "West", "San Francisco", "Breads", "Bakery", 350},
{"2025-07-02", "West", "Seattle", "Beverages", "Tea", 180},
{"2025-07-02", "East", "Jersey", "Breads", "Cookie", 75},
{"2025-07-03", "West", "San Francisco", "Beverages", "Juice", 210},
{"2025-07-03", "East", "Boston", "Breads", "Bakery", 420}
})
Dim pvCache As IPivotCache = fpSpread1.AsWorkbook().PivotCaches.Create("Sheet1!A1:F20")
' Configure pivot table's fields.
Dim pvTable As IPivotTable = pvCache.CreatePivotTable(sheet1.Cells("I1"))
Dim pvFields As IPivotFields = pvTable.PivotFields
pvTable.AddDataField(pvFields("Quantity"), "Sum of quantity", ConsolidationFunction.Sum)
pvFields("Region").Orientation = PivotFieldOrientation.Row
pvFields("City").Orientation = PivotFieldOrientation.Row
pvFields("Category").Orientation = PivotFieldOrientation.Column
pvFields("Product").Orientation = PivotFieldOrientation.Column
pvFields("OrderDate").Orientation = PivotFieldOrientation.Page
' Set the sort order of the "Category" field to ascending.
pvFields("Category").AutoSortOrder = FieldSortType.Ascending