RemoveRangeGroup Method (SheetView)

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
C#

'Declaration
 
Public Sub RemoveRangeGroup( _
   ByVal startIndex As Integer, _
   ByVal count As Integer, _
   ByVal isRowGroup As Boolean _
)

'Usage
 
Dim instance As SheetView
Dim startIndex As Integer
Dim count As Integer
Dim isRowGroup As Boolean
 
instance.RemoveRangeGroup(startIndex, count, isRowGroup)

public void RemoveRangeGroup( 
   int startIndex,
   int count,
   bool 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.

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

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

Reference

SheetView Class
SheetView Members