Specifying What the User Can Select

In This Topic

By default, the component allows users to select a cell, a column, a row, a range of cells, or the entire sheet. You can customize what the user can select by working with the operation mode of the sheet (OperationMode property). The settings are based on the OperationMode enumeration. You can specify what the user is allowed to select in normal operation mode with the SelectionBlockOptions property. You can allow the user to select multiple blocks in normal operation mode with the SelectionPolicy property.

The settings of the OperationMode property affect user interaction with the sheet, that is, what the user can select, but not necessarily what the application can select.

Selected row and editable cell

The following table summarizes the options available for specifying what users can select and edit on the sheet:

User can select	User can edit	OperationMode Setting
Cell, row, column, any range of cells, entire sheet	Active cell	Normal
Only one row	Active Cell	RowMode
Only one row	Nothing	SingleSelect
Nothing	Nothing	ReadOnly
Multiple contiguous rows	Nothing	MultiSelect
Multiple discontiguous rows	Nothing	ExtendedSelect

Using the Properties Window

At design time, in the Properties window, select the FpSpread component.
Select the Sheets property.
Click the button to display the SheetView Collection Editor.
In the Members list, select the sheet for which to set the operation mode.
Select the OperationMode property, then select one of the values from the drop-down list of values.
Click OK to close the editor.

Using a Shortcut

To set the overall user interaction mode of the sheet, set the Sheet’s OperationMode property.

Example

This example code sets the sheet to allow users to select only rows and only edit the active cell.

C#	Copy Code
// Set the operation mode and let users select only rows. fpSpread1.Sheets[0].OperationMode = FarPoint.Web.Spread.OperationMode.RowMode;

VB	Copy Code
' Set the operation mode and let users select only rows. FpSpread1.Sheets(0).OperationMode = FarPoint.Web.Spread.OperationMode.RowMode

Using Code

To set the overall user interaction mode of the sheet, set the OperationMode property for a SheetView object.
Assign the SheetView object you have created to one of the sheets in the component.

Example

This example code sets the sheet to allow users to select only cells or ranges of cells, including multiple ranges of cells. They cannot select columns, rows, or the entire sheet.

C#	Copy Code
// Set operation mode and let users select only a row. FarPoint.Web.Spread.SheetView newsheet = new FarPoint.Web.Spread.SheetView(); newsheet.OperationMode = FarPoint.Web.Spread.OperationMode.RowMode; // Assign the SheetView object to a sheet. fpSpread1.Sheets[0] = newsheet;

Copy Code

// Set operation mode and let users select only a row.
FarPoint.Web.Spread.SheetView newsheet = new FarPoint.Web.Spread.SheetView();
newsheet.OperationMode = FarPoint.Web.Spread.OperationMode.RowMode;
// Assign the SheetView object to a sheet.
fpSpread1.Sheets[0] = newsheet;

VB	Copy Code
' Set operation mode and let users select only a row. Dim newsheet As New FarPoint.Web.Spread.SheetView() newsheet.OperationMode = FarPoint.Web.Spread.OperationMode.RowMode ' Assign the SheetView object to a sheet. FpSpread1.Sheets(0) = newsheet

Copy Code

' Set operation mode and let users select only a row.
Dim newsheet As New FarPoint.Web.Spread.SheetView()
newsheet.OperationMode = FarPoint.Web.Spread.OperationMode.RowMode
' Assign the SheetView object to a sheet.
FpSpread1.Sheets(0) = newsheet

Using the Spread Designer

Select the sheet tab for the sheet for which you want to set the selection operation mode.
From the Settings menu, select the General icon, then select one of the choices from the Operation Mode area.
Click OK to close the Sheet Settings dialog.
From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.