Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / FetchGroupText Event
Example


In This Topic
    FetchGroupText Event
    In This Topic
    Occurs when spread creates the group bar.
    Syntax
    'Declaration
     
    Public Event FetchGroupText As FetchGroupTextEventHandler
    'Usage
     
    Dim instance As FpSpread
    Dim handler As FetchGroupTextEventHandler
     
    AddHandler instance.FetchGroupText, handler
    public event FetchGroupTextEventHandler FetchGroupText
    Event Data

    The event handler receives an argument of type FetchGroupTextEventArgs containing data related to this event. The following FetchGroupTextEventArgs properties provide information specific to this event.

    PropertyDescription
    Gets the Group object associated with the group header being created.  
    Gets or sets the text to be displayed in the group header.  
    Example
    This example uses the FetchGroupText event.
    FpSpread1.ActiveSheetView.AllowColumnMove = true;
    FpSpread1.ActiveSheetView.GroupBarVisible = true;
    FpSpread1.ActiveSheetView.GroupBarBackColor = Drawing.Color.Salmon;
    FpSpread1.ActiveSheetView.GroupBarHeight = 50;
    FpSpread1.ActiveSheetView.GroupMaximumLevel = 5;
    FpSpread1.ActiveSheetView.AllowGroup = true;
    FarPoint.Web.Spread.GroupInfo gi = new FarPoint.Web.Spread.GroupInfo();
    gi.BackColor = Drawing.Color.Yellow;
    FarPoint.Web.Spread.GroupInf gi2 = new FarPoint.Web.Spread.GroupInfo();
    gi2.BackColor = Drawing.Color.Green;
    FarPoint.Web.Spread.GroupInfoCollection gic = new FarPoint.Web.Spread.GroupInfoCollection();
    gic.Add(gi);
    FpSpread1.ActiveSheetView.GroupInfos.Add(gic(0));
    
    protected void FpSpread1_FetchGroupText(object sender, FarPoint.Web.Spread.FetchGroupTextEventArgs e)
            {
                e.Text = "test";
            }
    FpSpread1.ActiveSheetView.AllowColumnMove = True
    FpSpread1.ActiveSheetView.GroupBarVisible = True
    FpSpread1.ActiveSheetView.GroupBarBackColor = Drawing.Color.Salmon
    FpSpread1.ActiveSheetView.GroupBarHeight = 50
    FpSpread1.ActiveSheetView.GroupMaximumLevel = 5
    FpSpread1.ActiveSheetView.AllowGroup = True
    Dim gi As New FarPoint.Web.Spread.GroupInfo
    gi.BackColor = Drawing.Color.Yellow
    Dim gi2 As New FarPoint.Web.Spread.GroupInfo
    gi2.BackColor = Drawing.Color.Green
    Dim gic As New FarPoint.Web.Spread.GroupInfoCollection()
    gic.Add(gi)
    FpSpread1.ActiveSheetView.GroupInfos.Add(gic(0))
    
    Protected Sub FpSpread1_FetchGroupText(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.FetchGroupTextEventArgs) Handles FpSpread1.FetchGroupText
                e.Text = "Group Header Text"
    End Sub
    See Also