ExpandRangeGroup(Int32,Int32,Boolean,Boolean) Method

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

Syntax

Visual Basic
C#

'Declaration
 
Overloads Sub ExpandRangeGroup( _
   ByVal level As Integer, _
   ByVal endIndex As Integer, _
   ByVal isRowGroup As Boolean, _
   ByVal expand As Boolean _
)

'Usage
 
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)

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.

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 Basic

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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

IRangeGroupSupport Interface
IRangeGroupSupport Members
Overload List