Removes rows or columns from an outline (range group) from a specified start index by a specified amount, and returns them to individual rows or columns.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim startIndex As Integer
Dim count As Integer
Dim isRowGroup As Boolean
instance.RemoveRangeGroup(startIndex, count, isRowGroup) |
Parameters
- startIndex
- Starting index
- count
- Number of the rows or columns to remove from being grouped together in the outline (range group)
- isRowGroup
- Whether the outline (range group) is of rows
Example
This example removes the specified range group.
| C# | Copy Code |
|---|
fpSpread1.ActiveSheet.AddRangeGroup(0, 20, true);
fpSpread1.ActiveSheet.AddRangeGroup(0, 10, true);
fpSpread1.ActiveSheet.AddRangeGroup(0, 5, true);
fpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow;
fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced;
private void Button1_Click(object sender, System.EventArgs e)
{
fpSpread1.ActiveSheet.RemoveRangeGroup(0, 10, true);
} |
| Visual Basic | Copy Code |
|---|
FpSpread1.ActiveSheet.AddRangeGroup(0, 20, True)
FpSpread1.ActiveSheet.AddRangeGroup(0, 10, True)
FpSpread1.ActiveSheet.AddRangeGroup(0, 5, True)
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
FpSpread1.ActiveSheet.RemoveRangeGroup(0, 10, True)
End Sub |
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
