-
Spread Windows Forms 18 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
- 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
- Customizing Drawing
- Touch Support with the Component
- Spread Designer Guide
- Assembly Reference
- Import and Export Reference
- Version Comparison Reference
Adding a Custom Sort Dialog
You can add a custom sort dialog in the enhanced row filter. The custom sort dialog allows you to add multiple sort keys and specify what to sort on.
You can also specify the sorting behavior with the AutoSortEnhancedMode property.
Using Code
Set the AutoFilterMode property to EnhancedContextMenu.
Set the AutoSortEnhancedContextMenu property to true.
Set the AllowAutoFilter property for the columns to be filtered.
Set the AllowAutoSort property for the columns to be sorted.
Example
This example adds the custom sort dialog option.
fpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu;
fpSpread1.ActiveSheet.AutoSortEnhancedContextMenu = true;
fpSpread1.ActiveSheet.Columns[0].AllowAutoFilter = true;
fpSpread1.ActiveSheet.Columns[0].AllowAutoSort = true;
fpSpread1.ActiveSheet.Columns[1].AllowAutoFilter = true;
fpSpread1.ActiveSheet.Columns[1].AllowAutoSort = true;fpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu
fpSpread1.ActiveSheet.AutoSortEnhancedContextMenu = True
fpSpread1.ActiveSheet.Columns[0].AllowAutoFilter = True
fpSpread1.ActiveSheet.Columns[0].AllowAutoSort = True
fpSpread1.ActiveSheet.Columns[1].AllowAutoFilter = True
fpSpread1.ActiveSheet.Columns[1].AllowAutoSort = TrueUsing the Spread Designer
Select Sheet in the property grid.
Set AutoFilterMode to EnhancedContextMenu.
Set AutoSortEnhancedContextMenu to true.
Select the column in the Spread Designer. Then set AllowAutoFilter and AllowAutoSort to true in the property grid.