Back to Devexpress

SpreadsheetBehaviorOptions Properties

officefileapi-devexpress-dot-xtraspreadsheet-dot-spreadsheetbehavioroptions-dot-underscore-properties.md

latest6.5 KB
Original Source

SpreadsheetBehaviorOptions Properties

Provides options to restrict an end-user’s ability to manage a document within the SpreadsheetControl.

NameDescription
CellEditorProvides access to an option to handle data editing via the cell editor.
ColumnSpecifies whether column operations are permitted.
CommentProvides access to options that specify the document’s capability to manage comments.
CopyGets or sets whether the Copy operation is permitted.
CreateNewGets or sets whether the Create New Document operation is permitted.
CutGets or sets whether the Cut operation is permitted.
DataValidationProvides access to options that specify the document’s capability to create or modify data validation rules.
DefaultMaxZoomFactorGets the maximum zoom factor that is set for the control, by default.
DefaultMinZoomFactorGets the minimum zoom factor that is set for the control, by default.
DragGets or sets whether the Drag operation is permitted.
DrawingProvides access to options that specify the document’s capability to perform different operations over drawing objects.
DropGets or sets whether the Drop operation is permitted.
EncryptGets or sets whether the encryption operations are permitted.
FillHandleProvides access to an option which turns the Fill Handle feature on or off.
FreezePanesGets or sets whether the Freeze Panes operation is permitted.
FunctionNameCultureSpecifies whether to localize function names in the Spreadsheet control.
GroupProvides access to options that specify the document’s capability to create and modify groups of rows and columns.
LocalizeBooleanValuesSpecifies whether to localize TRUE and FALSE values in the Spreadsheet control.
MaxZoomFactorGets or sets the upper limit of document zooming.
MinZoomFactorGets or sets the lower limit of document zooming.
MoveRangeGets or sets whether the end-user operation, which includes dragging the selected range and moving it, is permitted.
OfficeScrollingGets or sets whether or not the Office Scrolling feature is enabled.
OpenGets or sets whether an Open Document operation is permitted.
PasteGets or sets whether the Paste operation is permitted.
PrintGets or sets whether printing operations are permitted.
ProtectionProvides access to options that specify the document’s capability to apply or remove workbook protection.
RowSpecifies whether row operations are permitted.
SaveGets or sets whether the Save Document operation is permitted.
SaveAsGets or sets whether the Save Document As operation is permitted.
SaveButtonAlwaysEnabledGets or sets a value indicating whether the Save button should always be enabled on the ribbon.
SelectionReturns an object that provides access to cell selection options.
ShowPopupMenuGets or sets whether the popup menu can be displayed in the SpreadsheetControl.
TouchGets or sets whether the touch device input is analyzed.
UseSkinColorsSpecifies whether skin or system colors should be used for cell font and background.
WorksheetSpecifies whether worksheet operations are permitted.
ZoomingGets or sets whether the Zoom operation is permitted.

See Also

SpreadsheetBehaviorOptions Class

SpreadsheetBehaviorOptions Members

DevExpress.XtraSpreadsheet Namespace