MESCIUS SPREAD for Windows Forms 15.0J
GroupInfos プロパティ
使用例 

シートのグループ化情報オブジェクトのコレクションを取得または設定します。
構文
'宣言
 
Public Property GroupInfos As GroupInfoCollection
public GroupInfoCollection GroupInfos {get; set;}

プロパティ値

グループ情報オブジェクトのコレクションを含む GroupInfoCollection
使用例
次のサンプル コードは、グループ化バーのプロパティを指定します。
fpSpread1.AllowColumnMove = true;
fpSpread1.ActiveSheet.GroupBarInfo.Visible = true;
fpSpread1.ActiveSheet.GroupBarInfo.BackColor = Color.Aquamarine;
fpSpread1.ActiveSheet.GroupBarInfo.Height = 75;
fpSpread1.ActiveSheet.GroupMaximumLevel = 3;
fpSpread1.ActiveSheet.GroupBarInfo.GroupVerticalIndent = 20;
fpSpread1.ActiveSheet.AllowGroup = true;

FarPoint.Win.Spread.GroupInfo gi = new FarPoint.Win.Spread.GroupInfo();
gi.BackColor = Color.Yellow;

FarPoint.Win.Spread.GroupInfo gi2 = new FarPoint.Win.Spread.GroupInfo();
gi2.BackColor = Color.Green;

FarPoint.Win.Spread.GroupInfoCollection gic = new FarPoint.Win.Spread.GroupInfoCollection();
gic.AddRange(new FarPoint.Win.Spread.GroupInfo[] { gi, gi2 });

fpSpread1.ActiveSheet.GroupInfos.Add(gic.Item[0]);
FpSpread1.AllowColumnMove = True
FpSpread1.ActiveSheet.GroupBarInfo.Visible = True
FpSpread1.ActiveSheet.GroupBarInfo.BackColor = Color.Aquamarine
FpSpread1.ActiveSheet.GroupBarInfo.Height = 75
FpSpread1.ActiveSheet.GroupMaximumLevel = 3
FpSpread1.ActiveSheet.GroupBarInfo.GroupVerticalIndent = 20
FpSpread1.ActiveSheet.AllowGroup = True

Dim gi As New FarPoint.Win.Spread.GroupInfo
gi.BackColor = Color.Yellow

Dim gi2 As New FarPoint.Win.Spread.GroupInfo
gi2.BackColor = Color.Green

Dim gic As New FarPoint.Win.Spread.GroupInfoCollection()
gic.AddRange(New FarPoint.Win.Spread.GroupInfo() {gi, gi2})

FpSpread1.ActiveSheet.GroupInfos.Add(gic.Item(0))
参照

SheetView クラス
SheetView メンバ

開発者ガイド

グループ化の外観
グループ化

 

 


© MESCIUS inc. All rights reserved.