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