Spread Windows Forms 6.0 Product Documentation
ExpandRangeGroup(Int32,Int32,Boolean,Boolean) Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > IRangeGroupSupport Interface > ExpandRangeGroup Method : ExpandRangeGroup(Int32,Int32,Boolean,Boolean) Method


level
Level of the outline (range group) to expand or collapse
endIndex
End index of the outline (range group) to expand or collapse
isRowGroup
Whether the outline (range group) is of rows
expand
Whether the action is to expand

Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Overloads Sub ExpandRangeGroup( _
   ByVal level As Integer, _
   ByVal endIndex As Integer, _
   ByVal isRowGroup As Boolean, _
   ByVal expand As Boolean _
)
Visual Basic (Usage)Copy Code
Dim instance As IRangeGroupSupport
Dim level As Integer
Dim endIndex As Integer
Dim isRowGroup As Boolean
Dim expand As Boolean
 
instance.ExpandRangeGroup(level, endIndex, isRowGroup, expand)
C# 
void ExpandRangeGroup( 
   int level,
   int endIndex,
   bool isRowGroup,
   bool expand
)

Parameters

level
Level of the outline (range group) to expand or collapse
endIndex
End index of the 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;
}
rangeGroupSupport.ExpandRangeGroup(2, 9, 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
rangeGroupSupport.ExpandRangeGroup(2, 9, 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.