Specifying the Operation Mode

• Spread Designer Instructions
• ActiveX Instructions
• DLL Instructions

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.