»Spread for Windows Forms  » Product Tour  » Operation Modes

jump to: - select feature - Welcome to the Spread for... Annotation Mode Auto Complete Borders Cell Notes Cell Types Charting Conditional Formatting Control Layer DataBinding Drag Drop Drag Fill Excel Compatibility Filtering Fonts/Colors Formulas Formula Textbox Freezing Rows/Columns Grouping Outline Grouping (Excel-l... Hierarchy Import Export Merging Move Rows/Columns Multiple Headers Operation Modes Printing Printing to PDF Reporting Search Shapes Sheets Sorting Spans Spread Designer SubEditors Unbound Undo/Redo Viewports Zoom Rate this tour

Operation Modes

By default, sheets allow users to select a cell, a column, a row, a range of cells, or the entire sheet. You can customize how selection occurs and what can be selected by working with the operation mode of the sheet and with the selection policy and unit of the sheet.

The settings of the OperationMode and the SelectionBlockOptions properties affect user interaction with the sheet, that is, what the user can select, but not necessarily what the application can select. You can also restrict which cells can be edited by using the RestrictRows and RestrictColumns methods for the sheet. This restricts users from entering data beyond the next row or column.



You can control whether users can only select:

• Cells
• Rows
• Columns
• Sheet
• Combination
• Cells, ranges of cells, or multiple ranges of cells
• Only rows, no editing
• Only rows, editing
• Multiple contiguous rows, no editing
• Multiple noncontiguous rows, no editing