Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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