With these enumerations, you can set how much the user can interact with the sheet by controlling the ability to select a row and to edit a cell.

In Normal mode, the default sheet operations are available. No row is highlighted when the user clicks on a cell. Client-side scripting is not turned off.

In ReadOnly mode, the user cannot select any rows for highlighting nor edit any cells. In fact, the client-side scripting is turned off, so that the scroll bars, if any, are not displayed. The user can page through the data, but not edit any of it. The sheet is said to be "read-only" and there is no active cell.

In SingleSelect mode, the user can only select a row, but still cannot edit any of the cells. The spreadsheet operates like a list box in that the user can select a single row in the sheet, similar to a single-selection list box. The selected row is highlighted. There is no active cell, since cells cannot be edited. Client-side scripting is not turned off.

In RowMode mode, the user can select a row in the sheet and can edit any individual cell in that row by double-clicking the cell. The selected (active) row is highlighted. When the user begins typing data in the active cell the row remains highlighted. The user can click another cell to make that the active cell. Once the user clicks on a cell in a different row, the highlighting moves to that row. Client-side scripting is not turned off.

In MultiSelect the user can select multiple contiguous rows in the spreadsheet (as one would in a multiple-select list box)

In ExtendedSelect mode, the user can select multiple discontiguous rows in the spreadsheet (as one would in an extended-select list box)