Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / AllowGroup Property
Example


In This Topic
    AllowGroup Property
    In This Topic
    Gets or sets whether a user can group rows.
    Syntax
    'Declaration
     
    Public Property AllowGroup As Boolean
    'Usage
     
    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 users to use Outlook-style grouping; false to prohibit grouping
    Example
    This example removes a group item if it belongs to the collection.
    FpSpread1.ActiveSheetView.AllowColumnMove = true;
    FpSpread1.ActiveSheetView.GroupBarVisible = true;
    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]);
    if (gic.Contains(gi)) {
        gic.Remove(gi);
    }
    
    
    FpSpread1.ActiveSheetView.AllowColumnMove = True
    FpSpread1.ActiveSheetView.GroupBarVisible = True
    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.AddRange(New FarPoint.Web.Spread.GroupInfo() {gi, gi2})
    FpSpread1.ActiveSheetView.GroupInfos.Add(gic(0))
    If gic.Contains(gi) Then
    gic.Remove(gi)
    End If
    
    See Also

    Reference

    SheetView Class
    SheetView Members

    User-Task Documentation

    Grouping Rows