Sets the column index in the data model that corresponds to the specified column index in the sheet.
Syntax
Visual Basic (Usage) | Copy Code |
---|
Dim instance As SheetView
Dim viewColumn As Integer
Dim modelColumn As Integer
Dim value As Integer
value = instance.SetModelColumnForViewColumn(viewColumn, modelColumn) |
Parameters
- viewColumn
- Column index in the sheet
- modelColumn
- Column index in the data model
Return Value
Integer previous column index in the data model that is mapped to the specified column index in the sheet
Exceptions
Example
This example sets the model column index in the data model that corresponds to the specified view column index on the sheet.
C# | Copy Code |
---|
private void fpSpread1LeaveCell(object sender, FarPoint.Win.Spread.LeaveCellEventArgs e)
{
int i;
i = fpSpread1.ActiveSheet.SetModelColumnForViewColumn(e.Column, 1);
MessageBox.Show("The previous model column index mapped to the specified view column 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.SetModelColumnForViewColumn(e.Column, 1)
MessageBox.Show("The previous model column index mapped to the specified view column 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