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 |
|
Set the background color of the grouping bar |
|
|
Set the height of the grouping bar |
|
|
Set whether to display the grouping bar |
|
|
Set the maximum number of levels of grouping allowed |
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]); |
|
| 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)) |
|
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.