Spread Windows Forms 6.0 Product Documentation
ExpandRangeGroup(RangeGroupInfo,Boolean,Boolean) Method
See Also Example Support Options

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > IRangeGroupSupport Interface > ExpandRangeGroup Method : ExpandRangeGroup(RangeGroupInfo,Boolean,Boolean) Method

Visual Basic (Declaration)
Visual Basic (Usage)
C#

group: Outline (range group) to expand or collapse

isRowGroup: Whether the outline (range group) is of rows

expand: Whether the action is to expand

Expands or collapses an outline (range group) of rows or columns, by specified group.

Syntax

Visual Basic (Declaration)
Overloads Sub ExpandRangeGroup( _ ByVal group As RangeGroupInfo, _ ByVal isRowGroup As Boolean, _ ByVal expand As Boolean _ )

Visual Basic (Usage)	Copy Code
Dim instance As IRangeGroupSupport Dim group As RangeGroupInfo Dim isRowGroup As Boolean Dim expand As Boolean instance.ExpandRangeGroup(group, isRowGroup, expand)

C#
void ExpandRangeGroup( RangeGroupInfo group, bool isRowGroup, bool expand )

Parameters

group: Outline (range group) to expand or collapse
isRowGroup: Whether the outline (range group) is of rows
expand: Whether the action is to expand

Example

This example expands the second group in the range.

C#	Copy Code
fpSpread1.ActiveSheet.AddRangeGroup(0, 20, true); fpSpread1.ActiveSheet.AddRangeGroup(0, 10, true); fpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow; fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced; FarPoint.Win.Spread.IRangeGroupSupport rangeGroupSupport = ((FarPoint.Win.Spread.IRangeGroupSupport)(fpSpread1.ActiveSheet)); if ((rangeGroupSupport == null)) { return; } FarPoint.Win.Spread.RangeGroupInfo[] rgi = rangeGroupSupport.GetRangeGroupInfo(2, true); rangeGroupSupport.ExpandRangeGroup(rgi[0], true, true);

Copy Code

fpSpread1.ActiveSheet.AddRangeGroup(0, 20, true);
fpSpread1.ActiveSheet.AddRangeGroup(0, 10, true);
fpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow;
fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced;

FarPoint.Win.Spread.IRangeGroupSupport rangeGroupSupport = ((FarPoint.Win.Spread.IRangeGroupSupport)(fpSpread1.ActiveSheet));
if ((rangeGroupSupport == null)) {
    return;
}
FarPoint.Win.Spread.RangeGroupInfo[] rgi = rangeGroupSupport.GetRangeGroupInfo(2, true);
rangeGroupSupport.ExpandRangeGroup(rgi[0], true, true);

Visual Basic	Copy Code
FpSpread1.ActiveSheet.AddRangeGroup(0, 20, True) FpSpread1.ActiveSheet.AddRangeGroup(0, 10, True) FpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow FpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced Dim rangeGroupSupport As FarPoint.Win.Spread.IRangeGroupSupport = CType(FpSpread1.ActiveSheet, FarPoint.Win.Spread.IRangeGroupSupport) If rangeGroupSupport Is Nothing Then Return End If Dim rgi() As FarPoint.Win.Spread.RangeGroupInfo = rangeGroupSupport.GetRangeGroupInfo(2, True) rangeGroupSupport.ExpandRangeGroup(rgi(0), True, True)

Visual Basic

Copy Code

FpSpread1.ActiveSheet.AddRangeGroup(0, 20, True)
FpSpread1.ActiveSheet.AddRangeGroup(0, 10, True)
FpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow
FpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced

Dim rangeGroupSupport As FarPoint.Win.Spread.IRangeGroupSupport = CType(FpSpread1.ActiveSheet, FarPoint.Win.Spread.IRangeGroupSupport)
If rangeGroupSupport Is Nothing Then
   Return
End If
Dim rgi() As FarPoint.Win.Spread.RangeGroupInfo = rangeGroupSupport.GetRangeGroupInfo(2, True)
rangeGroupSupport.ExpandRangeGroup(rgi(0), True, True)

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Syntax

Parameters

Example

Requirements

See Also

Reference