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. |
| 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. |
| 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. |
See Also