Spread Windows Forms 7.0 Product Documentation
AddRangeGroup Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > IRangeGroupSupport Interface : AddRangeGroup Method


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

Glossary Item Box

Groups a range of rows or columns into an outline from a specified start index by a specified amount.

Syntax

Visual Basic (Declaration) 
Sub AddRangeGroup( _
   ByVal startIndex As Integer, _
   ByVal count As Integer, _
   ByVal isRowGroup As Boolean _
) 
Visual Basic (Usage)Copy Code
Dim instance As IRangeGroupSupport
Dim startIndex As Integer
Dim count As Integer
Dim isRowGroup As Boolean
 
instance.AddRangeGroup(startIndex, count, isRowGroup)
C# 
void AddRangeGroup( 
   int startIndex,
   int count,
   bool isRowGroup
)

Parameters

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

Example

This example adds a group to the range.
C#Copy Code
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.AddRangeGroup(0, 4, true);
Visual BasicCopy Code
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.AddRangeGroup(0, 4, 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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.