fpSpread1.Sheets.Count = 2;
fpSpread1.Sheets[0].GroupBarInfo.Visible = true;
fpSpread1.Sheets[0].GroupBarInfo.Text = "Group Bar of Sheet1";
fpSpread1.Sheets[0].GroupBarInfo.ForeColor = Color.Green;
fpSpread1.Sheets[0].GroupBarInfo.Font = new Font("Tahama", 10.0f, FontStyle.Bold | FontStyle.Underline);
fpSpread1.Sheets[0].GroupBarInfo.Height = 30;
fpSpread1.Sheets[1].GroupBarInfo.Visible = true;
fpSpread1.Sheets[1].GroupBarInfo.Text = "Group Bar of Sheet2";
fpSpread1.Sheets[1].GroupBarInfo.BackColor = Color.GreenYellow;
fpSpread1.Sheets[1].GroupBarInfo.ForeColor = Color.Blue;
fpSpread1.Sheets[1].GroupBarInfo.Font = new Font("Tahama", 10.0f, FontStyle.Italic);
fpSpread1.AllowColumnMove = true;
fpSpread1.Sheets[0].AllowGroup = true;
fpSpread1.Sheets[1].AllowGroup = true;
private void button1_Click(object sender, EventArgs e)
{
fpSpread1.Sheets[0].GroupBarInfo.ResetText();
}
FpSpread1.Sheets.Count = 2
FpSpread1.Sheets(0).GroupBarInfo.Visible = True
FpSpread1.Sheets(0).GroupBarInfo.Text = "Group Bar of Sheet1"
FpSpread1.Sheets(0).GroupBarInfo.ForeColor = Color.Green
FpSpread1.Sheets(0).GroupBarInfo.Font = New Font("Tahama", 10.0F, FontStyle.Bold Or FontStyle.Underline)
FpSpread1.Sheets(0).GroupBarInfo.Height = 30
FpSpread1.Sheets(1).GroupBarInfo.Visible = True
FpSpread1.Sheets(1).GroupBarInfo.Text = "Group Bar of Sheet2"
FpSpread1.Sheets(1).GroupBarInfo.BackColor = Color.GreenYellow
FpSpread1.Sheets(1).GroupBarInfo.ForeColor = Color.Blue
FpSpread1.Sheets(1).GroupBarInfo.Font = New Font("Tahama", 10.0F, FontStyle.Italic)
FpSpread1.AllowColumnMove = True
FpSpread1.Sheets(0).AllowGroup = True
FpSpread1.Sheets(1).AllowGroup = True
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
FpSpread1.Sheets(0).GroupBarInfo.ResetText()
End Sub