Skip to main content

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.
Collapse Gets or sets whether end-users can collapse groups.
CollapseExpandOnProtectedSheet Gets or sets whether end-users can collapse or expand groups located 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.
Expand Gets or sets whether end-users can expand groups.
Group Gets or sets whether end-users can group data.
Ungroup Gets or sets whether end-users can ungroup data.
See Also