GroupingPolicy Property

Gets or sets grouping policy to collapse or expand rows when grouping occurs.

Syntax

Visual Basic
C#

'Declaration
 
Public Property GroupingPolicy As GroupingPolicy

'Usage
 
Dim instance As SheetView
Dim value As GroupingPolicy
 
instance.GroupingPolicy = value
 
value = instance.GroupingPolicy

public GroupingPolicy GroupingPolicy {get; set;}

Remarks

The GroupingPolicy property only applies to new groups.

Example

This example sets the GroupingPolicy property.

fpSpread1.AllowColumnMove = true;
fpSpread1.Sheets[0].GroupBarInfo.Visible = true;
fpSpread1.Sheets[0].AllowGroup = true;
fpSpread1.Sheets[0].GroupingPolicy = FarPoint.Win.Spread.Model.GroupingPolicy.CollapseAll;

Visual Basic

FpSpread1.AllowColumnMove = True
FpSpread1.Sheets(0).GroupBarInfo.Visible = True
FpSpread1.Sheets(0).AllowGroup = True
FpSpread1.Sheets(0).GroupingPolicy = FarPoint.Win.Spread.Model.GroupingPolicy.CollapseAll

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

SheetView Class
SheetView Members