Spread Windows Forms 9.0 Product Documentation
ExpandRangeGroup(RangeGroupInfo,Boolean,Boolean) Method
Example 


Outline (range group) to expand or collapse
Whether the outline (range group) is of rows
Whether the action is to expand
Expands or collapses an outline (range group) of rows or columns, by specified group.
Syntax
'Declaration
 
Overloads Sub ExpandRangeGroup( _
   ByVal group As RangeGroupInfo, _
   ByVal isRowGroup As Boolean, _
   ByVal expand As Boolean _
) 
'Usage
 
Dim instance As IRangeGroupSupport
Dim group As RangeGroupInfo
Dim isRowGroup As Boolean
Dim expand As Boolean
 
instance.ExpandRangeGroup(group, isRowGroup, expand)
void ExpandRangeGroup( 
   RangeGroupInfo group,
   bool isRowGroup,
   bool expand
)

Parameters

group
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;
}
FarPoint.Win.Spread.RangeGroupInfo[] rgi = rangeGroupSupport.GetRangeGroupInfo(2, true);
rangeGroupSupport.ExpandRangeGroup(rgi[0], true, true);
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 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

See Also

Reference

IRangeGroupSupport Interface
IRangeGroupSupport Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.