Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / GetModelRowFromViewRow Method
Row index in sheet
Example


In This Topic
    GetModelRowFromViewRow Method
    In This Topic
    Gets a row index in a model for a specified row in a sheet.
    Syntax
    'Declaration
     
    Public Function GetModelRowFromViewRow( _
       ByVal row As Integer _
    ) As Integer
    'Usage
     
    Dim instance As SheetView
    Dim row As Integer
    Dim value As Integer
     
    value = instance.GetModelRowFromViewRow(row)
    public int GetModelRowFromViewRow( 
       int row
    )

    Parameters

    row
    Row index in sheet

    Return Value

    Integer row index for the original model corresponding to the specified sheet row
    Example
    This example returns the index for the specified row.
    private void FpSpread1ChildViewCreated(object sender, FarPoint.Web.Spread.CreateChildViewEventArgs e)
    {
          FarPoint.Web.Spread.SheetView sv;
          sv = e.SheetView;
          int i;
          i = sv.GetModelRowFromViewRow(1);
          Response.Write("The index in the model for the specified row is " + i.ToString());
    }
    
    Private Sub FpSpread1ChildViewCreated(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.CreateChildViewEventArgs) Handles
    FpSpread1.ChildViewCreated
          Dim sv As FarPoint.Web.Spread.SheetView
          Dim i As Integer
          sv = e.SheetView
          i = sv.GetModelRowFromViewRow(1)
          Response.Write("The index in the model for the specified row is " & i.ToString())
    End Sub
    
    See Also