PowerTools SPREAD for Windows Forms 10.0J
RangeGroupSummaryRowBelow プロパティ


集計行の方向が詳細データの下かどうかを取得または設定します。
構文
'Declaration
 
Public Property RangeGroupSummaryRowBelow As Boolean
'使用法
 
Dim instance As SheetView
Dim value As Boolean
 
instance.RangeGroupSummaryRowBelow = value
 
value = instance.RangeGroupSummaryRowBelow
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 メンバ

 

 


© 2004-2017, GrapeCity inc. All rights reserved.