Expands or collapses a specified outline (range group) of rows.
Syntax
Visual Basic (Usage) | Copy Code |
---|
Dim instance As Rows
Dim group As RangeGroupInfo
Dim expand As Boolean
instance.ExpandRangeGroup(group, expand) |
Parameters
- group
- Outline (range group) to expand or collapse
- expand
- Whether the action is to expand the outline
Example
This example expands one of the ranges in the group.
C# | Copy Code |
---|
fpSpread1.ActiveSheet.AddRangeGroup(0, 10, true);
fpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow;
fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced;
fpSpread1.ActiveSheet.Rows.AddGroup(0, 2);
private void Button1_Click(object sender, System.EventArgs e)
{
FarPoint.Win.Spread.RangeGroupInfo[] rgi = fpSpread1.ActiveSheet.Rows.GetRangeGroupInfo(1);
fpSpread1.ActiveSheet.Rows.ExpandRangeGroup(rgi[0], true);
}
|
Visual Basic | Copy Code |
---|
FpSpread1.ActiveSheet.AddRangeGroup(0, 10, True)
FpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow
FpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced
FpSpread1.ActiveSheet.Rows.AddGroup(0, 2)
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.Rows.GetRangeGroupInfo(1)
FpSpread1.ActiveSheet.Rows.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