Spread Windows Forms 11.0 Product Documentation
RangeGroupSummaryRowBelow Property
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : RangeGroupSummaryRowBelow Property
Gets or sets whether the direction of the summary row is below the detail.
Syntax
'Declaration
 
Public Property RangeGroupSummaryRowBelow As Boolean
'Usage
 
Dim instance As SheetView
Dim value As Boolean
 
instance.RangeGroupSummaryRowBelow = value
 
value = instance.RangeGroupSummaryRowBelow
public bool RangeGroupSummaryRowBelow {get; set;}
Example
This example sets the RangeGroupSummaryColumnBelow property.
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
See Also

Reference

SheetView Class
SheetView Members