[]
        
(Showing Draft Content)

Customizing the Group Bar

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 by setting the SheetView object's GroupMaximumLevel property.

See Also

Allowing the User to Group Rows

Using Grouping

Setting the Appearance of Grouped Rows

Creating a Custom Group

Interoperability of Grouping with Other Features