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.
CreateNew Gets or sets whether the Create New Document operation is permitted.
Cut Gets or sets whether the Cut operation is permitted.
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.
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.
Encrypt Gets or sets whether the encryption operations are permitted.
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.
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.
OfficeScrolling Gets or sets whether or not the Office Scrolling feature is enabled.
Open Gets or sets whether an Open Document operation is permitted.
Paste Gets or sets whether the Paste operation is permitted.
Print Gets or sets whether printing operations are permitted.
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.
SaveAs Gets or sets whether the Save Document As operation is permitted.
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.
Touch Gets or sets whether the touch device input is analyzed.
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.

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