Spread Windows Forms 8.0 Product Documentation
ClearRangeGroup Method (SheetView)
Example 


Whether the outline is a group of rows
Removes all the outlines (range grouping) from all rows or columns.
Syntax
'Declaration
 
Public Sub ClearRangeGroup( _
   ByVal isRowGroup As Boolean _
) 
'Usage
 
Dim instance As SheetView
Dim isRowGroup As Boolean
 
instance.ClearRangeGroup(isRowGroup)
public void ClearRangeGroup( 
   bool isRowGroup
)

Parameters

isRowGroup
Whether the outline is a group of rows
Example
This example clears the 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.ClearRangeGroup(true);
}
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.ClearRangeGroup(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

See Also

Reference

SheetView Class
SheetView Members

 

 


Copyright © GrapeCity, inc. All rights reserved.