.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+

SpreadsheetBehaviorOptions Members

Provides options to restrict an end-user's ability to manage a document within the SpreadsheetControl.

Constructors

Name Description
SpreadsheetBehaviorOptions()

Initializes a new instance of the SpreadsheetBehaviorOptions class with the default settings.

Properties

Name Description
CellEditor

Provides access to an option to handle data editing via the cell editor.

Column

Gets or sets whether column operations are permitted.

Comment

Provides access to options that specify the document's capability to manage comments.

Copy

Gets or sets whether the Copy operation is permitted.

CopyAllowed

Gets whether an end-user is allowed to perform the Copy operation.

CreateNew

Gets or sets whether the Create New Document operation is permitted.

CreateNewAllowed

Gets whether an end-user is allowed to create new documents.

Cut

Gets or sets whether the Cut operation is permitted.

CutAllowed

Gets whether an end-user is allowed to perform the Cut operation.

DataValidation

Provides access to options that specify the document's capability to create or modify data validation rules.

DefaultMaxZoomFactor

Gets the maximum zoom factor that is set for the control, by default.

DefaultMinZoomFactor

Gets the minimum zoom factor that is set for the control, by default.

Drag

Gets or sets whether the Drag operation is permitted.

DragAllowed

Gets whether an end-user is allowed to perform the Drag operation.

Drawing

Provides access to options that specify the document's capability to perform different operations over drawing objects.

Drop

Gets or sets whether the Drop operation is permitted.

DropAllowed

Gets whether an end-user is allowed to perform the Drop operation.

Encrypt

Gets or sets whether the encryption operations are permitted.

EncryptAllowed

Gets whether the encryption is allowed.

FillHandle

Provides access to an option which turns the Fill Handle feature on or off.

FreezePanes

Gets or sets whether the Freeze Panes operation is permitted.

FreezePanesAllowed

Gets whether an end-user is allowed to freeze panes.

FunctionNameCulture

Enables you to specify the culture setting for function names in a worksheet that is different from the control's culture settings.

Group

Provides access to options that specify the document's capability to create and modify groups of rows and columns.

MaxZoomFactor

Gets or sets the upper limit of document zooming.

MinZoomFactor

Gets or sets the lower limit of document zooming.

MoveRange

Gets or sets whether the end-user operation, which includes dragging the selected range and moving it, is permitted.

MoveRangeAllowed

Gets whether an end-user is allowed to drag and move the selected range.

OfficeScrolling

Gets or sets whether or not the Office Scrolling feature is enabled.

OfficeScrollingAllowed

Gets whether an end-user is allowed to use the office scrolling feature.

Open

Gets or sets whether an Open Document operation is permitted.

OpenAllowed

Gets whether an end-user is allowed to open documents.

Paste

Gets or sets whether the Paste operation is permitted.

PasteAllowed

Gets whether an end-user is allowed to perform the Paste operation.

Print

Gets or sets whether printing operations are permitted.

PrintAllowed

Gets whether an end-user is allowed to print documents.

Protection

Provides access to options that specify the document's capability to apply or remove workbook protection.

Row

Gets or sets whether row operations are permitted.

Save

Gets or sets whether the Save Document operation is permitted.

SaveAllowed

Gets whether an end-user is allowed to save documents.

SaveAs

Gets or sets whether the Save Document As operation is permitted.

SaveAsAllowed

Gets whether an end-user is allowed to perform the Save Document As operation.

SaveButtonAlwaysEnabled

Gets or sets a value indicating whether the Save button should always be enabled on the ribbon.

Selection

Returns an object that provides access to cell selection options.

ShowPopupMenu

Gets or sets whether the popup menu can be displayed in the SpreadsheetControl.

ShowPopupMenuAllowed

Gets whether an end-user is allowed to invoke the popup menu.

Touch

Gets or sets whether the touch device input is analyzed.

TouchAllowed

Gets whether an end-user is allowed to perform the Touch operation.

UseSkinColors

Specifies whether skin or system colors should be used for cell font and background.

Worksheet

Gets or sets whether worksheet operations are permitted.

Zooming

Gets or sets whether the Zoom operation is permitted.

ZoomingAllowed

Gets whether an end-user is allowed to zoom in and out documents.

Methods

Name Description
Assign(BaseOptions)

Copies all settings from the SpreadsheetBehaviorOptions 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) Determines whether the specified object is equal to the current object.
(Inherited from Object)
Equals(Object, Object) static Determines whether the specified object instances are considered equal.
(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() 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