OperationMode Property

Gets or sets the operation mode of the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Property OperationMode As OperationMode

'Usage
 
Dim instance As SheetView
Dim value As OperationMode
 
instance.OperationMode = value
 
value = instance.OperationMode

public OperationMode OperationMode {get; set;}

Property Value

OperationMode setting that sets the mode

Remarks

Refer to Understanding the Effect of Mode on Events for more information about how the OperationMode property works with events.

Example

This example creates a spreadsheet with 6 columns and 20 rows and single-selection mode in which the user can select a row but is unable to edit the data.

FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView;
int i,j;
sv.ColumnCount=6;
sv.PageSize=20;
sv.RowCount=20;
sv.OperationMode=FarPoint.Web.Spread.OperationMode.SingleSelect;
for(i=0;i<=19;i++)
{
for(j=0;j<=5;j++)
sv.SetValue(i,j,100+i);
}

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
Dim i,j As Integer
sv=FpSpread1.ActiveSheetView
sv.ColumnCount=6
sv.PageSize=20
sv.RowCount=20
sv.OperationMode=FarPoint.Web.Spread.OperationMode.SingleSelect
For i=0 To 19
For j=0 To 5
sv.SetValue(i,j,100+i)
Next j
Next i

Reference

SheetView Class
SheetView Members

User-Task Documentation

Specifying What the User Can Select