AJAX Support
Cell Merging
Cell Types
AJAX Extender Cell...
Conditional Format...
Data Binding
Excel Compatibilit...
Filtering
Formulas
Frozen Rows & Colu...
Grouping
Hierarchy
Import / Export
LayoutMode - Row T...
Load on Demand
Move Columns
Operation Modes
Order Entry Sample
Paging
Preview Row Summar...
Print/Print To PDF
Row Edit Templates
Scroll Tips
Searching
Sheets
Skins
Sorting
Spread Designer
Summary Aggregatio...
Unbound Mode
Worksheet
»
Spread for ASP.NET
»
Product Tour
»
Operation Modes
jump to:
- select feature -
Welcome to the Spread for...
AJAX Support
Cell Merging
Cell Types
AJAX Extender Cell Types
Conditional Formatting
Data Binding
Excel Compatibility
Filtering
Formulas
Frozen Rows & Columns
Grouping
Hierarchy
Import / Export
LayoutMode - Row Template
Load on Demand
Move Columns
Operation Modes
Order Entry Sample
Paging
Preview Row Summary
Print/Print To PDF
Row Edit Templates
Scroll Tips
Searching
Sheets
Skins
Sorting
Spread Designer
Summary Aggregation
Unbound Mode
Worksheet
Rate this Tour
Operation Modes
You can customize what the user can select by working with the operation mode of the sheet. By default, the component allows users to select a cell, a column, a row, a range of cells, or the entire sheet. The MultiRangeSelection property allows the user to select multiple discontiguous blocks with the control (Ctrl) key and the mouse.
Choose a mode then interact with the Spread to see the behavior change.
Select OperationMode
Normal
ReadOnly
RowMode
SingleSelect
MultiSelect
ExtendedSelect
A
B
C
D
E
F
G
H
1
2
3
Normal Mode
4
5
6
Member
Description
Normal
Allows users to perform default spreadsheet selecting and editing
ReadOnly
Allows users to see the data but not to select or edit any cell or row in the sheet
RowMode
Allows users to select (highlight) a single row only and to edit an individual cell in that row
SingleSelect
Allows users to select (highlight) a single row only but not to edit any cell
MultiSelect
Allows the user to select multiple contiguous rows in the spreadsheet (as one would in a multiple-select list box)
ExtendedSelect
Allows the user to select multiple discontiguous rows in the spreadsheet (as one would in an extended-select list box)