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.
This example adds the custom sort dialog option.
C# |
Copy Code
|
---|---|
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; |
VB |
Copy Code
|
---|---|
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 |