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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

SheetView Class
SheetView Members