Gets or sets the maximum number of levels of grouping for the sheet.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property GroupMaximumLevel As Integer |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim value As Integer
instance.GroupMaximumLevel = value
value = instance.GroupMaximumLevel |
| C# | |
|---|
public int GroupMaximumLevel {get; set;} |
Property Value
Integer number of allowed levels to display in grouping
Example
This example specifies the properties of the grouping bar.
| C# | Copy Code |
|---|
fpSpread1.AllowColumnMove = true;
fpSpread1.ActiveSheet.GroupBarInfo.Visible = true;
fpSpread1.ActiveSheet.GroupBarInfo.BackColor = Color.Aquamarine;
fpSpread1.ActiveSheet.GroupBarInfo.Height = 75;
fpSpread1.ActiveSheet.GroupMaximumLevel = 3;
fpSpread1.ActiveSheet.GroupBarInfo.GroupVerticalIndent = 20;
fpSpread1.ActiveSheet.AllowGroup = true;
FarPoint.Win.Spread.GroupInfo gi = new FarPoint.Win.Spread.GroupInfo();
gi.BackColor = Color.Yellow;
FarPoint.Win.Spread.GroupInfo gi2 = new FarPoint.Win.Spread.GroupInfo();
gi2.BackColor = Color.Green;
FarPoint.Win.Spread.GroupInfoCollection gic = new FarPoint.Win.Spread.GroupInfoCollection();
gic.AddRange(new FarPoint.Win.Spread.GroupInfo[] { gi, gi2 });
fpSpread1.ActiveSheet.GroupInfos.Add(gic.Item[0]);
|
| Visual Basic | Copy Code |
|---|
FpSpread1.AllowColumnMove = True
FpSpread1.ActiveSheet.GroupBarInfo.Visible = True
FpSpread1.ActiveSheet.GroupBarInfo.BackColor = Color.Aquamarine
FpSpread1.ActiveSheet.GroupBarInfo.Height = 75
FpSpread1.ActiveSheet.GroupMaximumLevel = 3
FpSpread1.ActiveSheet.GroupBarInfo.GroupVerticalIndent = 20
FpSpread1.ActiveSheet.AllowGroup = True
Dim gi As New FarPoint.Win.Spread.GroupInfo
gi.BackColor = Color.Yellow
Dim gi2 As New FarPoint.Win.Spread.GroupInfo
gi2.BackColor = Color.Green
Dim gic As New FarPoint.Win.Spread.GroupInfoCollection()
gic.AddRange(New FarPoint.Win.Spread.GroupInfo() {gi, gi2})
FpSpread1.ActiveSheet.GroupInfos.Add(gic.Item(0))
|
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
