.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
A newer version of this page is available. Switch to the current version.

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.
See Also