Spread for ASP.NET 11 Product Documentation
OperationMode Property
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : OperationMode Property
Gets or sets the operation mode of the sheet.
Syntax
'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);
}
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
See Also

Reference

SheetView Class
SheetView Members

User-Task Documentation

Specifying What the User Can Select