RemoveRangeGroup Method (IRangeGroupSupport)

Removes a range of rows or columns from the outline (range group) at the specified start index by a specified amount.

Syntax

Visual Basic
C#

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

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

void RemoveRangeGroup( 
   int startIndex,
   int count,
   bool isRowGroup
)

Parameters

startIndex: Start index
count: Number of rows or columns to remove
isRowGroup: Whether the outline (range group) is of rows

Example

This example removes the specified group from 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;
}
rangeGroupSupport.RemoveRangeGroup(0, 10, true);

Visual Basic

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
rangeGroupSupport.RemoveRangeGroup(0, 10, True)

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

IRangeGroupSupport Interface
IRangeGroupSupport Members