MESCIUS SPREAD for Windows Forms 15.0J
Visible プロパティ (GroupBarInfo)
使用例 

グループ化バーが表示されるかどうかを取得または設定します。
構文
'宣言
 
Public Property Visible As Boolean
public bool Visible {get; set;}
使用例
次のサンプルコードは、グループバーのプロパティを設定します。
fpSpread1.Sheets.Count = 2;
fpSpread1.Sheets[0].GroupBarInfo.Visible = true;
fpSpread1.Sheets[0].GroupBarInfo.Text = "This is GroupBar 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[0].GroupBarInfo.GroupVerticalIndent = 2;
fpSpread1.Sheets[1].GroupBarInfo.Visible = true;
fpSpread1.Sheets[1].GroupBarInfo.Text = "This is GroupBar 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;
FpSpread1.Sheets.Count = 2
FpSpread1.Sheets(0).GroupBarInfo.Visible = True
FpSpread1.Sheets(0).GroupBarInfo.Text = "This is GroupBar 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(0).GroupBarInfo.GroupVerticalIndent = 2
FpSpread1.Sheets(1).GroupBarInfo.Visible = True
FpSpread1.Sheets(1).GroupBarInfo.Text = "This is GroupBar 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
参照

GroupBarInfo クラス
GroupBarInfo メンバ

 

 


© MESCIUS inc. All rights reserved.