You can customize the appearance of the group bar at the top of the grouping display.
You can hide or display the grouping bar at the top of the sheet. The properties on the sheet (GroupBarInfo object) include:
| GroupBarInfo Property | Description |
|
BackColor |
Set the background color of the grouping bar |
|
Height |
Set the height of the grouping bar |
|
Visible |
Set whether to display the grouping bar |
|
GroupVerticalIndent |
Set the vertical distance between group names (when more than one group name is used) in the grouping bar |
You can set the maximum levels of grouping allowed on the sheet. The property on the SheetView object is:
| SheetView Property | Description |
|
GroupMaximumLevel |
Set the maximum number of levels of grouping allowed |
Return to the overview of Managing Grouping of Rows of User Data