Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / FetchGroupText Event

In This Topic
    FetchGroupText Event
    In This Topic
    Occurs when spread creates the group bar.
    Public Event FetchGroupText As FetchGroupTextEventHandler
    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.

    Gets the Group object associated with the group header being created.  
    Gets or sets the text to be displayed in the group header.  
    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();
    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()
    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