Skip to main content

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 Specifies 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 Specifies whether to localize function names in the Spreadsheet control.
Group Provides access to options that specify the document’s capability to create and modify groups of rows and columns.
LocalizeBooleanValues Specifies whether to localize TRUE and FALSE values in the Spreadsheet control.
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 Specifies 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 Specifies 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, 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