FarPoint.Win.Spread Assembly Reference  
GroupingPolicy Property
See Also  Example
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : GroupingPolicy Property


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

Syntax

C# 
public GroupingPolicy GroupingPolicy {get; set;}
Visual Basic (Declaration) 
Public Property GroupingPolicy As GroupingPolicy
Visual Basic (Usage)Copy Code
Dim instance As FpSpread
Dim value As GroupingPolicy
 
instance.GroupingPolicy = value
 
value = instance.GroupingPolicy

Remarks

The GroupingPolicy property only applies to new groups.

Example

This example sets the GroupingPolicy property.
C#Copy Code
fpSpread1.AllowColumnMove = true;
fpSpread1.Sheets[0].GroupBarVisible = true;
fpSpread1.Sheets
[0].AllowGroup = true;
fpSpread1.GroupingPolicy = FarPoint.Win.Spread.Model.GroupingPolicy.CollapseAll;
Visual BasicCopy Code
fpSpread1.AllowColumnMove = true;
fpSpread1.Sheets[0].GroupBarVisible = true;
fpSpread1.Sheets[0].AllowGroup = true;
fpSpread1.GroupingPolicy = FarPoint.Win.Spread.Model.GroupingPolicy.CollapseAll;

See Also