Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Property OperationMode As OperationMode | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SheetView Dim value As OperationMode instance.OperationMode = value value = instance.OperationMode | |
| C# | |
|---|---|
public OperationMode OperationMode {get; set;} | |
Property Value
OperationMode setting that determines the modeExceptions
| Exception | Description |
|---|---|
| System.ComponentModel.InvalidEnumArgumentException | Specified operation mode is not valid |
Remarks
When this property is set to OperationMode.Normal or OperationMode.ReadOnly,
- You can set the FpSpread class or SpreadView class SelectionBlockOptions property to specify that users can select only certain items, such as just cells, columns, or rows.
- If you want to customize the sheet so that users and the application can only select certain items, set the SelectionUnit property.
- If you want to allow users to select single cells, a range of cells, or multiple ranges of cells, set the SelectionPolicy property.
When this property is set, related properties are also set automatically as summarized in this table:
| OperationMode Setting |
Effect on Other Properties |
|---|---|
| Normal | SelectionPolicy = SelectionPolicy.Range |
| SelectionUnit = SelectionUnit.Cell | |
| ReadOnly | SelectionPolicy = SelectionPolicy.Range |
| SelectionUnit = SelectionUnit.Cell | |
| RowMode | SelectionPolicy = SelectionPolicy.Range |
| SelectionUnit = SelectionUnit.Cell | |
| SingleSelect | SelectionPolicy = SelectionPolicy.Single |
| SelectionUnit = SelectionUnit.Row | |
| MultiSelect | SelectionPolicy = SelectionPolicy.MultiRange |
| SelectionUnit = SelectionUnit.Row | |
| ExtendedSelect | SelectionPolicy = SelectionPolicy.MultiRange |
| SelectionUnit = SelectionUnit.Row |
For information on the settings of OperationMode, refer to the OperationMode enumeration.
Example
This example sets the operation mode for the active sheet.
| C# | Copy Code |
|---|---|
fpSpread1.ActiveSheet.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode; | |
| Visual Basic | Copy Code |
|---|---|
FpSpread1.ActiveSheet.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode | |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8