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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
