GroupingPolicy Property (SheetView)

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;}

Example

This example sets the GroupingPolicy property.

FpSpread1.ActiveSheetView.AllowColumnMove = true; 
FpSpread1.ActiveSheetView.GroupBarVisible = true; 
FpSpread1.ActiveSheetView.AllowGroup = true;
FpSpread1.ActiveSheetView.GroupingPolicy = FarPoint.Web.Spread.Model.GroupingPolicy.ExpandAll;

VB.NET

FpSpread1.ActiveSheetView.AllowColumnMove = True
FpSpread1.ActiveSheetView.GroupBarVisible = True
FpSpread1.ActiveSheetView.AllowGroup = True
FpSpread1.ActiveSheetView.GroupingPolicy = FarPoint.Web.Spread.Model.GroupingPolicy.ExpandAll

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

SheetView Class
SheetView Members