Use the following properties to restrict operations users can perform on workbooks:
The example below shows how to disable the New and Open operations in the Spreadsheet control.

C# |
spreadsheetControl.Options.Behavior.CreateNew = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled;
spreadsheetControl.Options.Behavior.Open = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled;
|
VB |
spreadsheetControl.Options.Behavior.CreateNew = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled
spreadsheetControl.Options.Behavior.Open = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled
|
Use the following properties to restrict operations users can perform on worksheets:
The example below shows how to hide the Delete Sheet and Hide Sheet commands in the Spreadsheet control.

C# |
spreadsheetControl.Options.Behavior.Worksheet.Delete = DevExpress.XtraSpreadsheet.DocumentCapability.Hidden;
spreadsheetControl.Options.Behavior.Worksheet.Hide = DevExpress.XtraSpreadsheet.DocumentCapability.Hidden;
|
VB |
spreadsheetControl.Options.Behavior.Worksheet.Delete = DevExpress.XtraSpreadsheet.DocumentCapability.Hidden
spreadsheetControl.Options.Behavior.Worksheet.Hide = DevExpress.XtraSpreadsheet.DocumentCapability.Hidden
|
Use the following properties to restrict operations users can perform on rows and columns:
The example below shows how to disable the Delete operation for row and columns in the Spreadsheet control.

C# |
spreadsheetControl.Options.Behavior.Row.Delete = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled;
spreadsheetControl.Options.Behavior.Column.Delete = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled;
|
VB |
spreadsheetControl.Options.Behavior.Row.Delete = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled
spreadsheetControl.Options.Behavior.Column.Delete = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled
|
Use the following properties to restrict operations users can perform on cells and cell ranges:
The example below shows how to disable multiple selection in the Spreadsheet control and change the direction in which an active cell moves when a user presses ENTER.
C# |
spreadsheetControl1.Options.Behavior.Selection.AllowMultiSelection = false;
spreadsheetControl1.Options.Behavior.Selection.MoveActiveCellMode = DevExpress.XtraSpreadsheet.MoveActiveCellModeOnEnterPress.Right;
|
VB |
spreadsheetControl1.Options.Behavior.Selection.AllowMultiSelection = False
spreadsheetControl1.Options.Behavior.Selection.MoveActiveCellMode = DevExpress.XtraSpreadsheet.MoveActiveCellModeOnEnterPress.Right
|
Use the following properties to restrict clipboard operations:
The example below shows how to disable clipboard operations in the Spreadsheet control.

C# |
spreadsheetControl.Options.Behavior.Cut = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled;
spreadsheetControl.Options.Behavior.Copy = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled;
spreadsheetControl.Options.Behavior.Paste = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled;
|
VB |
spreadsheetControl.Options.Behavior.Cut = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled
spreadsheetControl.Options.Behavior.Copy = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled
spreadsheetControl.Options.Behavior.Paste = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled
|