Spread for ASP.NET 8.0 Product Documentation > Developer's Guide > Customizing User Interaction > Customizing Grouping of Rows of User Data > Allowing the User to Group Rows |
By default, the spreadsheet does not allow the user to group the rows of a spreadsheet. You can turn on this feature and allow grouping of rows for an entire sheet. Besides allowing grouping, you also need to allow columns to move, since the user performs grouping by clicking and dragging a column header into the group bar, which is similar to the act of moving a column. Also, the group bar must be visible and the column headers (at least one row) should be visible.
Use the AllowGroup property of the sheet to turn on grouping. Use the GroupBarVisible property of the sheet to display the group bar (the area at the top of the sheet into which the user can drag column headers. Remember to set the AllowColumnMove property of the sheet to true to allow the user to click and drag column headers. Unless you are using the default value, set the ColumnHeaderVisible property of the sheet to true to ensure that the column headers are displayed. The following image shows the control before the user drags the column header:
You can turn on or off the row headers; these have no effect on the display of grouping.
You can set the maximum number of levels of grouping that the end user can set. This limits the number of column headers that can be dragged consecutively to the group bar.
To understand how grouping works for the end user, refer to Using Grouping.
Set the AllowGroup, AllowColumMove, and the GroupBarVisible properties to allow user grouping.
This example allows the user to group rows.
C# |
Copy Code
|
---|---|
FpSpread1.ActiveSheetView.AllowColumnMove = true; FpSpread1.ActiveSheetView.GroupBarVisible = true; FpSpread1.ActiveSheetView.AllowGroup = true; |
VB |
Copy Code
|
---|---|
FpSpread1.ActiveSheetView.AllowColumnMove = True FpSpread1.ActiveSheetView.GroupBarVisible = True FpSpread1.ActiveSheetView.AllowGroup = True |