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

集計行の方向が詳細データの下かどうかを取得または設定します。
構文
'宣言
 
Public Property RangeGroupSummaryRowBelow As Boolean
public bool RangeGroupSummaryRowBelow {get; set;}
使用例
次のサンプルコードは、RangeGroupSummaryColumnBelowプロパティを設定します。
fpSpread1.ActiveSheet.Rows.Count = 11;
fpSpread1.ActiveSheet.Columns.Count = 6;
fpSpread1.InterfaceRenderer = null;
fpSpread1.ActiveSheet.RangeGroupBackgroundColor = Color.LightGreen;
fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced;
fpSpread1.ActiveSheet.AddRangeGroup(0, 8, true);
fpSpread1.ActiveSheet.AddRangeGroup(0, 5, true);
fpSpread1.ActiveSheet.AddRangeGroup(1, 3, false);
fpSpread1.ActiveSheet.AddRangeGroup(1, 2, false);
fpSpread1.Sheets[0].RangeGroupSummaryRowBelow = true;
fpSpread1.Sheets[0].RangeGroupSummaryColumnRight = true;
FpSpread1.ActiveSheet.Rows.Count = 11
FpSpread1.ActiveSheet.Columns.Count = 6
FpSpread1.InterfaceRenderer = Nothing
FpSpread1.ActiveSheet.RangeGroupBackgroundColor = Color.LightGreen
FpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced
FpSpread1.ActiveSheet.AddRangeGroup(0, 8, True)
FpSpread1.ActiveSheet.AddRangeGroup(0, 5, True)
FpSpread1.ActiveSheet.AddRangeGroup(1, 3, False)
FpSpread1.ActiveSheet.AddRangeGroup(1, 2, False)
FpSpread1.Sheets(0).RangeGroupSummaryRowBelow = True
FpSpread1.Sheets(0).RangeGroupSummaryColumnRight = True
参照

SheetView クラス
SheetView メンバ

 

 


© MESCIUS inc. All rights reserved.