AddRangeGroup Method (SheetView)

Groups all the rows or columns from the specified start index by the specified amount to an outline (range group).

Syntax

Visual Basic
C#

'Declaration
 
Public Sub AddRangeGroup( _
   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.AddRangeGroup(startIndex, count, isRowGroup)

public void AddRangeGroup( 
   int startIndex,
   int count,
   bool isRowGroup
)

Parameters

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

Example

This example adds a range group to the sheet.

fpSpread1.ActiveSheet.AddRangeGroup(0, 10, true); 
fpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow; 
fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced;

Visual Basic

FpSpread1.ActiveSheet.AddRangeGroup(0, 10, True)
FpSpread1.ActiveSheet.RangeGroupBackGroundColor = Color.Yellow
FpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced

Reference

SheetView Class
SheetView Members