Skip to main content

SpreadsheetBehaviorOptions Properties

Provides options to restrict an end-user’s ability to manage a document within the SpreadsheetControl.
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.
See Also