Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / ISheetDataModel Interface / IsEditable Method
Row index of the cell
Column index of the cell
Example


In This Topic
    IsEditable Method (ISheetDataModel)
    In This Topic
    Determines whether the contents of the cell at the specified row and column are editable.
    Syntax
    'Declaration
     
    Function IsEditable( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) As Boolean
    'Usage
     
    Dim instance As ISheetDataModel
    Dim row As Integer
    Dim column As Integer
    Dim value As Boolean
     
    value = instance.IsEditable(row, column)
    bool IsEditable( 
       int row,
       int column
    )

    Parameters

    row
    Row index of the cell
    column
    Column index of the cell

    Return Value

    true if the cell contents can be edited; false otherwise
    Example
    This example returns whether the specified cell can be edited in the model.
    private void ChangeDataModel(FarPoint.Web.Spread.FpSpread ss, FarPoint.Web.Spread.Model.ISheetDataModel isd)
    {
        isd.SetValue(0, 0, "Primary");
        ss.ActiveSheetView.DataModel = (FarPoint.Web.Spread.Model.ISheetDataModel)isd;
        bool b;
        b = isd.IsEditable(0, 0);
        Response.Write("The cell can be edited is" + b.ToString());
    }
    
    private void PageLoad(object sender, System.EventArgs e)
    {
        ChangeDataModel(FpSpread1, FpSpread1.ActiveSheetView.DataModel);    
    }
    
    Private Sub ChangeDataModel(ByVal ss As FarPoint.Web.Spread.FpSpread, ByVal isd As FarPoint.Web.Spread.Model.ISheetDataModel)
        isd.SetValue(0, 0, "Primary")
        ss.ActiveSheetView.DataModel = isd
        Dim b As Boolean
        b = isd.IsEditable(0, 0)
        Response.Write("The cell can be edited is" & b.ToString())
    End Sub
    
    Private Sub PageLoad(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        ChangeDataModel(FpSpread1, FpSpread1.ActiveSheetView.DataModel)
    End Sub
    See Also