Back to Devexpress

SpreadsheetBehaviorOptions Members

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

latest10.1 KB
Original Source

SpreadsheetBehaviorOptions Members

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

Constructors

NameDescription
SpreadsheetBehaviorOptions()Initializes a new instance of the SpreadsheetBehaviorOptions class with the default settings.

Properties

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.

Methods

NameDescription
Assign(BaseOptions)Copies all settings from the SpreadsheetBehaviorOptions object passed as a parameter.
BeginUpdate()Locks the BaseOptions object by disallowing visual updates until the EndUpdate or CancelUpdate method is called. Inherited from BaseOptions.
CancelUpdate()Unlocks the BaseOptions object after it has been locked by the BeginUpdate method, without causing an immediate visual update. Inherited from BaseOptions.
EndUpdate()Unlocks the BaseOptions object after a call to the BeginUpdate method and causes an immediate visual update. Inherited from BaseOptions.
Equals(Object, Object) staticDetermines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object)Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode()Serves as the default hash function. Inherited from Object.
GetType()Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protectedCreates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) staticDetermines whether the specified Object instances are the same instance. Inherited from Object.
ToString()Returns a string representing the currently enabled options. Inherited from BaseOptions.

See Also

SpreadsheetBehaviorOptions Class

DevExpress.XtraSpreadsheet Namespace