Spread Windows Forms 6.0 Product Documentation
GetRangeGroupInfo Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > IRangeGroupSupport Interface : GetRangeGroupInfo Method


level
Level of outline (range group)
isRowGroup
Whether the outline (range group) is of rows

Glossary Item Box

Gets all the outlines (range groups) in a specified level.

Syntax

Visual Basic (Declaration) 
Function GetRangeGroupInfo( _
   ByVal level As Integer, _
   ByVal isRowGroup As Boolean _
) As RangeGroupInfo()
Visual Basic (Usage)Copy Code
Dim instance As IRangeGroupSupport
Dim level As Integer
Dim isRowGroup As Boolean
Dim value() As RangeGroupInfo
 
value = instance.GetRangeGroupInfo(level, isRowGroup)
C# 
RangeGroupInfo[] GetRangeGroupInfo( 
   int level,
   bool isRowGroup
)

Parameters

level
Level of outline (range group)
isRowGroup
Whether the outline (range group) is of rows

Return Value

Collection of outlines (range groups) in the level

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);
Visual BasicCopy 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

See Also

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