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

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class > 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 is a group of rows

expand: Whether the action is to expand the outline

Expands or collapses a specified outline (range group) of rows or columns.

Syntax

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

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

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

Parameters

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

Example

This example expands the specified level of the group range, in this case the range group from 0 to 10.

C#	Copy Code
fpSpread1.ActiveSheet.AddRangeGroup(0, 20, true); fpSpread1.ActiveSheet.AddRangeGroup(0, 10, true); fpSpread1.ActiveSheet.AddRangeGroup(0, 5, true); fpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow; fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced; private void Button1_Click(object sender, System.EventArgs e) { FarPoint.Win.Spread.RangeGroupInfo[] rgi = fpSpread1.ActiveSheet.GetRangeGroupInfo(2, true); fpSpread1.ActiveSheet.ExpandRangeGroup(rgi[0], true, true); }

Copy Code

fpSpread1.ActiveSheet.AddRangeGroup(0, 20, true);
fpSpread1.ActiveSheet.AddRangeGroup(0, 10, true);
fpSpread1.ActiveSheet.AddRangeGroup(0, 5, true);
fpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow;
fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced;
    
private void Button1_Click(object sender, System.EventArgs e) 
{
FarPoint.Win.Spread.RangeGroupInfo[] rgi = fpSpread1.ActiveSheet.GetRangeGroupInfo(2, true);
fpSpread1.ActiveSheet.ExpandRangeGroup(rgi[0], true, true);
}

Visual Basic	Copy Code
FpSpread1.ActiveSheet.AddRangeGroup(0, 20, True) FpSpread1.ActiveSheet.AddRangeGroup(0, 10, True) FpSpread1.ActiveSheet.AddRangeGroup(0, 5, True) FpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow FpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim rgi() As FarPoint.Win.Spread.RangeGroupInfo = FpSpread1.ActiveSheet.GetRangeGroupInfo(2, True) FpSpread1.ActiveSheet.ExpandRangeGroup(rgi(0), True, True) End Sub

Visual Basic

Copy Code

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

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim rgi() As FarPoint.Win.Spread.RangeGroupInfo = FpSpread1.ActiveSheet.GetRangeGroupInfo(2, True)
FpSpread1.ActiveSheet.ExpandRangeGroup(rgi(0), True, True)
End Sub

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

Syntax

Parameters

Example

Requirements

See Also

Reference