Spread for ASP.NET 8.0 Product Documentation > Developer's Guide > Customizing User Interaction > Customizing Grouping of Rows of User Data > 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 |
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 |
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)) |