Skip to main content

SpreadsheetGroupBehaviorOptions Members

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

Constructors

Name Description
SpreadsheetGroupBehaviorOptions() Initializes a new instance of the SpreadsheetGroupBehaviorOptions class with the default settings.

Properties

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.

Methods

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