»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

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)