|
»Spread for Windows Forms
» Product Tour
» Operation Modes
|
|
jump to:
|
|
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