SpreadsheetBehaviorOptions Properties
Provides options to restrict an end-user’s ability to manage a document within the SpreadsheetControl.
Name | Description |
---|---|
Cell |
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. |
Copy |
Gets whether an end-user is allowed to perform the Copy operation. |
Create |
Gets or sets whether the Create New Document operation is permitted. |
Create |
Gets whether an end-user is allowed to create new documents. |
Cut | Gets or sets whether the Cut operation is permitted. |
Cut |
Gets whether an end-user is allowed to perform the Cut operation. |
Data |
Provides access to options that specify the document’s capability to create or modify data validation rules. |
Default |
Gets the maximum zoom factor that is set for the control, by default. |
Default |
Gets the minimum zoom factor that is set for the control, by default. |
Drag | Gets or sets whether the Drag operation is permitted. |
Drag |
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. |
Drop |
Gets whether an end-user is allowed to perform the Drop operation. |
Encrypt | Gets or sets whether the encryption operations are permitted. |
Encrypt |
Gets whether the encryption is allowed. |
Fill |
Provides access to an option which turns the Fill Handle feature on or off. |
Freeze |
Gets or sets whether the Freeze Panes operation is permitted. |
Freeze |
Gets whether an end-user is allowed to freeze panes. |
Function |
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. |
Localize |
Specifies whether to localize TRUE and FALSE values in the Spreadsheet control. |
Max |
Gets or sets the upper limit of document zooming. |
Min |
Gets or sets the lower limit of document zooming. |
Move |
Gets or sets whether the end-user operation, which includes dragging the selected range and moving it, is permitted. |
Move |
Gets whether an end-user is allowed to drag and move the selected range. |
Office |
Gets or sets whether or not the Office Scrolling feature is enabled. |
Office |
Gets whether an end-user is allowed to use the office scrolling feature. |
Open | Gets or sets whether an Open Document operation is permitted. |
Open |
Gets whether an end-user is allowed to open documents. |
Paste | Gets or sets whether the Paste operation is permitted. |
Paste |
Gets whether an end-user is allowed to perform the Paste operation. |
Gets or sets whether printing operations are permitted. | |
Print |
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. |
Save |
Gets whether an end-user is allowed to save documents. |
Save |
Gets or sets whether the Save Document As operation is permitted. |
Save |
Gets whether an end-user is allowed to perform the Save Document As operation. |
Save |
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. |
Show |
Gets or sets whether the popup menu can be displayed in the Spreadsheet |
Show |
Gets whether an end-user is allowed to invoke the popup menu. |
Touch | Gets or sets whether the touch device input is analyzed. |
Touch |
Gets whether an end-user is allowed to perform the Touch operation. |
Use |
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. |
Zooming |
Gets whether an end-user is allowed to zoom in and out documents. |
See Also