Spread Windows Forms 8.0 Product Documentation
ExpandRangeGroup Method (Columns)
Example 


Outline (range group) to expand or collapse
Whether the action is to expand the outline
Expands or collapses a specified outline (range group) of columns.
Syntax
'Declaration
 
Public Sub ExpandRangeGroup( _
   ByVal group As RangeGroupInfo, _
   ByVal expand As Boolean _
) 
'Usage
 
Dim instance As Columns
Dim group As RangeGroupInfo
Dim expand As Boolean
 
instance.ExpandRangeGroup(group, expand)
public void ExpandRangeGroup( 
   RangeGroupInfo group,
   bool expand
)

Parameters

group
Outline (range group) to expand or collapse
expand
Whether the action is to expand the outline
Example
This example expands the specified group range.
fpSpread1.ActiveSheet.AddRangeGroup(0, 10, false);
fpSpread1.ActiveSheet.AddRangeGroup(0, 5, false);
fpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow;
fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced;

private void Button1_Click(object sender, System.EventArgs e) 
{
FarPoint.Win.Spread.RangeGroupInfo[] rgi = fpSpread1.ActiveSheet.Columns.GetRangeGroupInfo(1);
fpSpread1.ActiveSheet.Columns.ExpandRangeGroup(rgi[0], true);
}
FpSpread1.ActiveSheet.AddRangeGroup(0, 10, False)
FpSpread1.ActiveSheet.AddRangeGroup(0, 5, False)
FpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow
FpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced

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.Columns.GetRangeGroupInfo(1)
FpSpread1.ActiveSheet.Columns.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

Reference

Columns Class
Columns Members

 

 


Copyright © GrapeCity, inc. All rights reserved.