Customizing the Group Bar

You can customize the appearance of the group bar at the top of the grouping display and you can hide or display the grouping bar at the top of the sheet. The properties on the sheet (SheetView object) include:

SheetView Property	Description
GroupBarBackColor	Set the background color of the grouping bar
GroupBarHeight	Set the height of the grouping bar
GroupBarVisible	Set whether to display the grouping bar
GroupMaximumLevel	Set the maximum number of levels of grouping allowed

Return to the overview of Customizing Grouping of Rows of User Data

Using Code

Set the AllowColumnMove, GroupBarVisible, and AllowGroup properties.
Specify the main group bar color with the GroupBarBackColor property.
Specify colors for subgroups with the GroupInfo class.

Example

This example sets the appearance for the group bar and the grouped rows.

C#	Copy Code
FpSpread1.ActiveSheetView.AllowColumnMove = true; FpSpread1.ActiveSheetView.GroupBarVisible = true; FpSpread1.ActiveSheetView.GroupBarBackColor = Color.Salmon; FpSpread1.ActiveSheetView.GroupBarHeight = 50; FpSpread1.ActiveSheetView.GroupMaximumLevel = 5; FpSpread1.ActiveSheetView.AllowGroup = true; FarPoint.Web.Spread.GroupInfo gi = new FarPoint.Web.Spread.GroupInfo(); gi.BackColor = Color.Yellow; FarPoint.Web.Spread.GroupInfo gi2 = new FarPoint.Web.Spread.GroupInfo(); gi2.BackColor = Color.Green; FarPoint.Web.Spread.GroupInfoCollection gic = new FarPoint.Web.Spread.GroupInfoCollection(); gic.AddRange(new FarPoint.Web.Spread.GroupInfo[] {gi, gi2}); FpSpread1.ActiveSheetView.GroupInfos.Add(gic[0]);

Copy Code

FpSpread1.ActiveSheetView.AllowColumnMove = true;
FpSpread1.ActiveSheetView.GroupBarVisible = true;
FpSpread1.ActiveSheetView.GroupBarBackColor = Color.Salmon;
FpSpread1.ActiveSheetView.GroupBarHeight = 50;
FpSpread1.ActiveSheetView.GroupMaximumLevel = 5;
FpSpread1.ActiveSheetView.AllowGroup = true;
FarPoint.Web.Spread.GroupInfo gi = new FarPoint.Web.Spread.GroupInfo();
gi.BackColor = Color.Yellow;
FarPoint.Web.Spread.GroupInfo gi2 = new FarPoint.Web.Spread.GroupInfo();
gi2.BackColor = Color.Green;
FarPoint.Web.Spread.GroupInfoCollection gic = new FarPoint.Web.Spread.GroupInfoCollection();
gic.AddRange(new FarPoint.Web.Spread.GroupInfo[] {gi, gi2});
FpSpread1.ActiveSheetView.GroupInfos.Add(gic[0]);

VB	Copy Code
FpSpread1.ActiveSheetView.AllowColumnMove = True FpSpread1.ActiveSheetView.GroupBarVisible = True FpSpread1.ActiveSheetView.GroupBarBackColor = Color.Salmon FpSpread1.ActiveSheetView.GroupBarHeight = 50 FpSpread1.ActiveSheetView.GroupMaximumLevel = 5 FpSpread1.ActiveSheetView.AllowGroup = True Dim gi As New FarPoint.Web.Spread.GroupInfo gi.BackColor = Color.Yellow Dim gi2 As New FarPoint.Web.Spread.GroupInfo gi2.BackColor = Color.Green Dim gic As New FarPoint.Web.Spread.GroupInfoCollection() gic.Add(gi) FpSpread1.ActiveSheetView.GroupInfos.Add(gic(0))

Copy Code

FpSpread1.ActiveSheetView.AllowColumnMove = True
FpSpread1.ActiveSheetView.GroupBarVisible = True
FpSpread1.ActiveSheetView.GroupBarBackColor = Color.Salmon
FpSpread1.ActiveSheetView.GroupBarHeight = 50
FpSpread1.ActiveSheetView.GroupMaximumLevel = 5
FpSpread1.ActiveSheetView.AllowGroup = True
Dim gi As New FarPoint.Web.Spread.GroupInfo
gi.BackColor = Color.Yellow
Dim gi2 As New FarPoint.Web.Spread.GroupInfo
gi2.BackColor = Color.Green
Dim gic As New FarPoint.Web.Spread.GroupInfoCollection()
gic.Add(gi)
FpSpread1.ActiveSheetView.GroupInfos.Add(gic(0))

Using the Spread Designer

Select the Settings menu.
Select the Group icon in the Other Settings section.
Set the various properties.
Click OK to close the dialog.
Use the View menu to show or hide the group bar.
Click Apply and Exit to close the Spread Designer.