SpreadsheetGroupBehaviorOptions Properties

Provides options to restrict an end-user’s ability to group data.

Name	Description
ChangeSettings	Gets or sets whether end-users can change group settings.
ChangeSettingsAllowed	Gets whether an end-user is allowed to change group settings.
Collapse	Gets or sets whether end-users can collapse groups.
CollapseAllowed	Gets whether an end-user is allowed to collapse groups.
CollapseExpandOnProtectedSheet	Gets or sets whether end-users can collapse or expand groups located on a protected worksheet.
CollapseExpandOnProtectedSheetAllowed	Gets whether an end-user is allowed to collapse or expand groups on a protected worksheet.
CollapseExpandOnReadOnlyControl	Gets or sets whether end-users can collapse or expand groups when the SpreadsheetControl’s ReadOnly property is set to true.
CollapseExpandOnReadOnlyControlAllowed	Gets whether an end-user is allowed to collapse or expand groups when the SpreadsheetControl is in a read-only state.
Expand	Gets or sets whether end-users can expand groups.
ExpandAllowed	Gets whether an end-user is allowed to expand groups.
Group	Gets or sets whether end-users can group data.
GroupAllowed	Gets whether an end-user is allowed to group data.
Ungroup	Gets or sets whether end-users can ungroup data.
UngroupAllowed	Gets whether an end-user is allowed to ungroup data.