Specifying the Operation Mode
Overview
Operation modes control how the sheet reacts to user interaction and the types of user interaction available. The operation mode you apply also limits user interaction such as moving the focus and selecting cells.
As described in the following list, you can set the sheet to operate like a single-selection, multiple-selection, or extended-selection list box. Choose from the following operation modes:
-
Normal
The default mode. Clicking a row selects the row. Clicking a column selects the column. Clicking a cell moves the focus to that cell. Double-clicking a cell turns on edit mode.
-
Read only
The cells, rows, and columns cannot receive the focus.
-
Row
Clicking a row moves the focus to that row. Double-clicking a cell moves the focus to that cell.
-
Single-selection
The sheet operates similarly to a single-selection list box. Clicking a row selects the row. One and only one row is selected at all times. The user cannot move the focus to an individual cell.
-
Multiple-selection
The sheet operates similarly to a multiple-selection list box. Clicking a row selects the row. The user can click additional rows to select them. Clicking a selected row deselects it. The user cannot move the focus to an individual cell.
-
Extended-selection
The sheet operates similarly to a extended-selection list box. Clicking a row selects the row. The user can click while pressing Ctrl to select additional rows. The user can click and press Shift to select a range of rows. Pressing Ctrl and clicking a selected row deselects it. The user cannot move the focus to an individual cell.
Note: Do not set the sheet to use multiple- or extended-selection operation mode if the sheet is using virtual mode. |