Spread Windows Forms 7.0 Product Documentation
GetRangeGroupInfo Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Rows Class : GetRangeGroupInfo Method


level
Level of the associated outline (range group)

Glossary Item Box

Gets the outlines (range groups) by level.

Syntax

Visual Basic (Declaration) 
Public Function GetRangeGroupInfo( _
   ByVal level As Integer _
) As RangeGroupInfo()
Visual Basic (Usage)Copy Code
Dim instance As Rows
Dim level As Integer
Dim value() As RangeGroupInfo
 
value = instance.GetRangeGroupInfo(level)
C# 
public RangeGroupInfo[] GetRangeGroupInfo( 
   int level
)

Parameters

level
Level of the associated outline (range group)

Return Value

RangeGroupInfo array containing all the range group information

Example

This example expands one of the ranges in the group.
C#Copy Code
fpSpread1.ActiveSheet.AddRangeGroup(0, 10, true); 
fpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow; 
fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced; 
fpSpread1.ActiveSheet.Rows.AddGroup(0, 2); 

private void Button1_Click(object sender, System.EventArgs e) 
{
FarPoint.Win.Spread.RangeGroupInfo[] rgi = fpSpread1.ActiveSheet.Rows.GetRangeGroupInfo(1);
fpSpread1.ActiveSheet.Rows.ExpandRangeGroup(rgi[0], true);
}
Visual BasicCopy Code
FpSpread1.ActiveSheet.AddRangeGroup(0, 10, True)
FpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow
FpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced
FpSpread1.ActiveSheet.Rows.AddGroup(0, 2)

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.Rows.GetRangeGroupInfo(1)
FpSpread1.ActiveSheet.Rows.ExpandRangeGroup(rgi(0), 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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.