Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / OperationMode Property
Example


In This Topic
    OperationMode Property
    In This Topic
    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