RangeGroupSummaryRowBelow Property

Gets or sets whether the direction of the summary row is below the detail.

Syntax

Visual Basic
C#

'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;

Visual Basic

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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

SheetView Class
SheetView Members