Occurs when spread creates the group bar.
Syntax
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.
| C# |  Copy Code |
|---|
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 | Copy Code |
|---|
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 |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
