FetchGroupText Event

Occurs when spread creates the group bar.

Syntax

Visual Basic
C#

'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.

Property	Description
Group	Gets the Group object associated with the group header being created.
Text	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";
        }

Visual Basic

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

Reference

FpSpread Class
FpSpread Members

Product Support Forum | Print this page