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.Reset();
}
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.Reset()
End Sub