Spread ASP.NET 14
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