private void Form1_Load(object sender, EventArgs e) { fpSpread1.Sheets.Count = 2; FarPoint.Win.Spread.GroupBarInfo test = new FarPoint.Win.Spread.GroupBarInfo(); test.BackColor = Color.Aquamarine; test.ForeColor = Color.DarkMagenta; test.Visible = true; test.Text = "Group Bar"; test.Font = new Font("Tahama", 10.0F, FontStyle.Bold | FontStyle.Underline); fpSpread1.Sheets[0].GroupBarInfo = test; fpSpread1.AllowColumnMove = true; fpSpread1.Sheets[0].AllowGroup = true; } private void button1_Click(object sender, EventArgs e) { fpSpread1.Sheets[0].GroupBarInfo.ResetFont(); fpSpread1.Sheets[0].GroupBarInfo.ResetBackColor(); fpSpread1.Sheets[0].GroupBarInfo.ResetForeColor(); }
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load FpSpread1.Sheets.Count = 2 Dim test As New FarPoint.Win.Spread.GroupBarInfo test.BackColor = Color.Aquamarine test.ForeColor = Color.DarkMagenta test.Visible = True test.Text = "Group Bar" test.Font = New Font("Tahama", 10.0F, FontStyle.Bold Or FontStyle.Underline) FpSpread1.Sheets(0).GroupBarInfo = test FpSpread1.AllowColumnMove = True FpSpread1.Sheets(0).AllowGroup = True End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click FpSpread1.Sheets(0).GroupBarInfo.ResetFont() FpSpread1.Sheets(0).GroupBarInfo.ResetBackColor() FpSpread1.Sheets(0).GroupBarInfo.ResetForeColor() End Sub