Skip to main content
BuyLog In
Office File API
Search in…
Docs > API Reference > DevExpress.XtraSpreadsheet > SpreadsheetBehaviorOptions > Members
A newer version of this page is available. .
All docs
V19.1
.NET Framework 4.5.2+
Office File API
Demo Application
Redistribution and Deployment
Spreadsheet Document API
Word Processing Document API
PDF Document API
Excel Export Library
Snap Report API
Zip Compression and Archive API
Barcode Generation API
Unit Conversion API
API Reference
DevExpress.BarCodes
DevExpress.Compression
DevExpress.Docs.Text
DevExpress.Office
DevExpress.Office.Drawing
DevExpress.Office.Export
DevExpress.Office.Export.Html
DevExpress.Office.Import
DevExpress.Office.Localization
DevExpress.Office.Options
DevExpress.Office.Services
DevExpress.Office.Utils
DevExpress.Pdf
DevExpress.Pdf.Localization
DevExpress.Snap
DevExpress.Spreadsheet
DevExpress.Spreadsheet.Charts
DevExpress.Spreadsheet.Drawings
DevExpress.Spreadsheet.Export
DevExpress.Spreadsheet.Formulas
DevExpress.Spreadsheet.Functions
DevExpress.UnitConversion
DevExpress.XtraPrinting
DevExpress.XtraPrintingLinks
DevExpress.XtraRichEdit
DevExpress.XtraRichEdit.API.Layout
DevExpress.XtraRichEdit.API.Native
DevExpress.XtraRichEdit.API.Native.Implementation
DevExpress.XtraRichEdit.Commands
DevExpress.XtraRichEdit.Export
DevExpress.XtraRichEdit.Export.Html
DevExpress.XtraRichEdit.Export.PlainText
DevExpress.XtraRichEdit.Export.Rtf
DevExpress.XtraRichEdit.Forms
DevExpress.XtraRichEdit.Import
DevExpress.XtraRichEdit.Localization
DevExpress.XtraRichEdit.Services
DevExpress.XtraRichEdit.Utils
DevExpress.XtraSpreadsheet
AfterDropRangeEventArgs
AfterDropRangeEventHandler
AfterFillRangeEventArgs
AfterFillRangeEventHandler
BeforeDragRangeEventArgs
BeforeDragRangeEventHandler
BeforeDropRangeEventArgs
BeforeDropRangeEventHandler
BeforeFillRangeEventArgs
BeforeFillRangeEventHandler
CellBeginEditEventHandler
CellCancelEditEventHandler
CellEditorCommitMode
CellEditorEnterValueMode
CellEditorMode
CellEndEditEventHandler
CellValueChangedAction
CellValueChangedEventHandler
DataBindingWarningEventArgs
DataBindingWarningEventHandler
DataBindingWarningType
DataTransferMode
DefinedNameDeletingEventArgs
DefinedNameDeletingEventHandler
DefinedNameEditingEventArgs
DefinedNameEditingEventHandler
DefinedNameEventArgsBase
DocumentCapability
DocumentPropertiesChangedEventArgs
DocumentPropertiesChangedEventHandler
DragDropOperationType
FillOperationType
FormulaAutoCompleteSearchMode
FunctionNameCulture
HyperlinkClickEventArgs
HyperlinkClickEventHandler
MoveActiveCellModeOnEnterPress
RealTimeDataOptions
RealTimeDataRefreshMode
ShowSelectionMode
SpreadsheetAxisLabelOverlappingOptions
SpreadsheetBehaviorOptions
Members
Constructors
Properties
Methods
SpreadsheetCellCancelEditEventArgs
SpreadsheetCellCancelEventArgs
SpreadsheetCellEditorBehaviorOptions
SpreadsheetCellEventArgs
SpreadsheetCellEventArgsBase
SpreadsheetCellOptions
SpreadsheetCellValidatingEventArgs
SpreadsheetChartsViewOptions
SpreadsheetClipboardOptions
SpreadsheetColumnBehaviorOptions
SpreadsheetCommentBehaviorOptions
SpreadsheetCompatibilityOptions
SpreadsheetCopyOptions
SpreadsheetCustomAssemblyBehavior
SpreadsheetDataSourceLoadingOptions
SpreadsheetDataValidationBehaviorOptions
SpreadsheetDecryptionError
SpreadsheetDecryptionException
SpreadsheetDrawingBehaviorOptions
SpreadsheetFillHandleBehaviorOptions
SpreadsheetFormulaAutoCompleteOptions
SpreadsheetGroupBehaviorOptions
SpreadsheetPivotTableFieldListOptions
SpreadsheetPivotTableFieldListStartPosition
SpreadsheetPrintOptions
SpreadsheetPrintRenderMode
SpreadsheetProtectionBehaviorOptions
SpreadsheetProtectionOptions
SpreadsheetRowBehaviorOptions
SpreadsheetSelectionOptions
SpreadsheetUnhandledExceptionEventArgs
SpreadsheetViewOptions
SpreadsheetWorksheetBehaviorOptions
UnhandledExceptionEventHandler
WorkbookCapabilitiesOptions
WorkbookEventOptions
WorkbookPrintOptions
WorkbookSaveOptions
DevExpress.XtraSpreadsheet.Export
DevExpress.XtraSpreadsheet.Export.Html
DevExpress.XtraSpreadsheet.Import
DevExpress.XtraSpreadsheet.Localization
DevExpress.XtraSpreadsheet.Services
Download CHM

SpreadsheetBehaviorOptions Members

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

Constructors

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

Properties

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 Enables you to specify the culture setting for function names in a worksheet that is different from the control’s culture settings.
Group Provides access to options that specify the document’s capability to create and modify groups of rows and columns.
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.
Print 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.

Methods

Name Description
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) static Determines 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() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines 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