FarPoint.Win.Spread
GroupState Enumeration
Example  See Also 
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace : GroupState Enumeration


Specifies the status of an outline (range group).

Syntax

Visual Basic (Declaration) 
Public Enum GroupState 
   Inherits Enum
Visual Basic (Usage)Copy Code
Dim instance As GroupState
C# 
public enum GroupState : Enum

Members

MemberDescription
Expanded Expanded status with the minus sign
Collapsed Collapsed status with the plus sign
PartCollapsed Internal use only: Ambiguous (or undetermined) status with the plus sign

Example

This example changes the color of the group depending on certain conditions.
C#Copy Code
private void fpSpread1_RangeGroupStateChanged(object sender, FarPoint.Win.Spread.RangeGroupStateChangedEventArgs e)
{
if ((e.IsRowGroup == false))
{
if ((e.RangeGroupInfo.State == FarPoint.Win.Spread.GroupState.Expanded))
{
e.View.Sheets[fpSpread1.ActiveSheetIndex].RangeGroupBackgroundColor = Color.Bisque;
}
}
}
Visual BasicCopy Code
Private Sub FpSpread1_RangeGroupStateChanged(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.RangeGroupStateChangedEventArgs)
Handles FpSpread1.RangeGroupStateChanged
If e.IsRowGroup = False Then
If e.RangeGroupInfo.State = FarPoint.Win.Spread.GroupState.Expanded Then
e.View.Sheets(FpSpread1.ActiveSheetIndex).RangeGroupBackgroundColor = Color.Bisque
End If
End If
End Sub

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.GroupState

See Also