Sets the row index in the data model that corresponds to the specified row index in the sheet.
Syntax
Visual Basic (Usage) | Copy Code |
---|
Dim instance As SheetView
Dim viewRow As Integer
Dim modelRow As Integer
Dim value As Integer
value = instance.SetModelRowForViewRow(viewRow, modelRow) |
Parameters
- viewRow
- Row index in the sheet
- modelRow
- Row index in the data model
Return Value
Integer previous row index in the data model that is mapped to the specified row index in the sheet
Exceptions
Example
This example sets the model row index in the data model that corresponds to the specified view row index on the sheet.
C# | Copy Code |
---|
private void fpSpread1LeaveCell(object sender, FarPoint.Win.Spread.LeaveCellEventArgs e)
{
int i;
i = fpSpread1.ActiveSheet.SetModelRowForViewRow(e.Row, 1);
MessageBox.Show("The previous model row index mapped to the specified view row is row " + i.ToString());
}
|
Visual Basic | Copy Code |
---|
Private Sub FpSpread1LeaveCell(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.LeaveCellEventArgs) Handles FpSpread1.LeaveCell
Dim i As Integer
i = FpSpread1.ActiveSheet.SetModelRowForViewRow(e.Row, 1)
MessageBox.Show("The previous model row index mapped to the specified view row is row " & i.ToString())
End Sub |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also