Spread Windows Forms 12.0 Product Documentation
LeaveCell Event
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : LeaveCell Event
Occurs when the user leaves a cell.
Syntax
'Declaration
 
Public Event LeaveCell As LeaveCellEventHandler
'Usage
 
Dim instance As FpSpread
Dim handler As LeaveCellEventHandler
 
AddHandler instance.LeaveCell, handler
public event LeaveCellEventHandler LeaveCell
Event Data

The event handler receives an argument of type LeaveCellEventArgs containing data related to this event. The following LeaveCellEventArgs properties provide information specific to this event.

PropertyDescription
Gets or sets whether to cancel the cell navigation.  
Gets the column index of the cell being left.  
Gets the column index of the cell being entered.  
Gets the row index of the cell being entered.  
Gets the row index index of the cell being left.  
Remarks

This event is raised by the OnLeaveCell method when the user leaves a cell.

For more details on the individual event arguments, refer to LeaveCellEventArgs members.

Example
This example raises the LeaveCell event when the user leaves a cell.
fpSpread1.EditMode = true;
Label1.Text = "Click on a different cell to fire the event";

private void fpSpread1_LeaveCell(object sender, FarPoint.Win.Spread.LeaveCellEventArgs e)
{
     ListBox1.Items.Add("LeaveCell event fired!");
}
FpSpread1.EditMode = True
Label1.Text = "Click on a different cell to fire the event"

Private Sub FpSpread1_LeaveCell(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.LeaveCellEventArgs) Handles FpSpread1.LeaveCell
     ListBox1.Items.Add("LeaveCell event fired!")
End Sub
See Also