Spread Windows Forms 12.0 Product Documentation
AllowGroup Property

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : AllowGroup Property
Gets or sets whether to allow the user to group rows on the sheet.
Public Property AllowGroup As Boolean
Dim instance As SheetView
Dim value As Boolean
instance.AllowGroup = value
value = instance.AllowGroup
public bool AllowGroup {get; set;}

Property Value

Boolean: true to allow the user to do Outlook-style grouping; false otherwise
This example allows grouping and inserts a grouping information item into the collection at the specified location.
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.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})

See Also


SheetView Class
SheetView Members

User-Task Documentation

Allowing the User to Group Rows