Gets or sets whether to allow the user to group rows on the sheet.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property AllowGroup As Boolean |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim value As Boolean
instance.AllowGroup = value
value = instance.AllowGroup |
| C# | |
|---|
public bool AllowGroup {get; set;} |
Property Value
Boolean:
true to allow the user to do Outlook-style grouping;
false otherwise
Example
This example allows grouping and inserts a grouping information item into the collection at the specified location.
| C# | Copy Code |
|---|
fpSpread1.AllowColumnMove = true;
fpSpread1.ActiveSheet.GroupBarInfo.Visible = true;
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.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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
