Skip to main content

SpreadsheetWorksheetBehaviorOptions Members

Provides options to restrict an end-user’s ability to manage worksheets of the workbook loaded into SpreadsheetControl.

Constructors

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

Properties

Name Description
Delete Gets or sets the document’s capability to delete worksheets.
DeleteAllowed Gets whether an end-user is allowed to delete worksheets.
Hide Gets or sets the document’s capability to hide worksheets.
HideAllowed Gets whether an end-user is allowed to hide worksheets.
Insert Gets or sets the document’s capability to insert new worksheets.
InsertAllowed Gets whether an end-user is allowed to insert worksheets.
Rename Gets or sets the document’s capability to rename worksheets.
RenameAllowed Gets whether an end-user is allowed to rename worksheets.
TabColor Gets or sets the document’s capability to change the colors of worksheet tabs.
TabColorAllowed Gets whether an end-user is allowed to change the colors of the worksheet tabs.
Unhide Gets or sets the document’s capability to unhide worksheets.
UnhideAllowed Gets whether an end-user is allowed to unhide worksheets.

Methods

Name Description
Assign(BaseOptions) Copies all settings from the SpreadsheetWorksheetBehaviorOptions 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