officefileapi-devexpress-dot-xtraspreadsheet-dot-spreadsheetgroupbehavioroptions-dot-underscore-members.md
Provides options to restrict an end-user’s ability to group data.
| Name | Description |
|---|---|
| SpreadsheetGroupBehaviorOptions() | Initializes a new instance of the SpreadsheetGroupBehaviorOptions class with the default settings. |
| 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. |
| Name | Description |
|---|---|
| Assign(BaseOptions) | Copies all settings from the SpreadsheetGroupBehaviorOptions object passed as a parameter. |
| BeginUpdate() | Locks the BaseOptions object by disallowing visual updates until the EndUpdate or CancelUpdate method is called. Inherited from BaseOptions. |
| CancelUpdate() | Unlocks the BaseOptions object after it has been locked by the BeginUpdate method, without causing an immediate visual update. Inherited from BaseOptions. |
| EndUpdate() | Unlocks the BaseOptions object after a call to the BeginUpdate method and causes an immediate visual update. Inherited from BaseOptions. |
| Equals(Object, Object) static | Determines whether the specified object instances are considered equal. Inherited from Object. |
| Equals(Object) | Determines whether the specified object is equal to the current object. Inherited from Object. |
| GetHashCode() | Serves as the default hash function. Inherited from Object. |
| GetType() | Gets the Type of the current instance. Inherited from Object. |
| MemberwiseClone() protected | Creates a shallow copy of the current Object. Inherited from Object. |
| ReferenceEquals(Object, Object) static | Determines whether the specified Object instances are the same instance. Inherited from Object. |
| ToString() | Returns a string representing the currently enabled options. Inherited from BaseOptions. |
See Also