Spread Windows Forms 10.0 Product Documentation
OperationMode Enumeration
Example Example 


Specifies how the sheet responds to user interaction and what selections are allowed.
Syntax
'Declaration
 
Public Enum OperationMode 
   Inherits System.Enum
'Usage
 
Dim instance As OperationMode
public enum OperationMode : System.Enum 
Members
MemberDescription
ExtendedSelectAllows the user to select multiple discontiguous rows in the spreadsheet (as one would in an extended-select list box)
MultiSelectAllows the user to select multiple contiguous rows in the spreadsheet (as one would in a multiple-select list box)
NormalAllows default spreadsheet operations
ReadOnlyProhibits the user from changing anything on this spreadsheet (and sheet has no active cell)
RowModeAllows the user to select rows in the spreadsheet, and edit individual cells in rows by double-clicking the cell
SingleSelectAllows the user to select single rows in the spreadsheet (as one would in a single-selection list box)
Remarks

Use these settings to 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. The user can select a row or column by clicking on the corresponding header cell. The user can select the entire sheet by clicking on the sheet corner. The user can select a range of cells by dragging over those cells. For a row or column or range, the first (upper left) cell is the active cell until the user clicks on another cell in that row or column or range. The user can click on an individual cell in the data area without selecting an entire row.

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.

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 rows are highlighted. There is no active cell, since cells cannot be edited.

In MultiSelect mode, the user can only select multiple contiguous rows, but still cannot edit any of the cells. The spreadsheet operates like a multiple-select list box in that the user can select rows that are together in the sheet, similar to a multiple-selection list box. The selected rows are highlighted. There is no active cell, since cells cannot be edited.

In ExtendedSelect mode, the user can only select multiple discontiguous rows, but still cannot edit any of the cells. The spreadsheet operates like an extended-select list box in that the user can select rows in the sheet, similar to an extended-selection list box. The selected rows are highlighted. There is no active cell, since cells cannot be edited.

In ReadOnly mode, the user cannot edit cells.

Example
fpSpread1.ActiveSheet.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode;
FpSpread1.ActiveSheet.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.OperationMode

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

FarPoint.Win.Spread Namespace
OperationMode Property (SheetView Class)
SelectionBlockOptions Enumeration

User-Task Documentation

Specifying What the User Can Select

 

 


Copyright © GrapeCity, inc. All rights reserved.