LeaveCell Event

Visual Basic
C#

'Declaration
 
Public Event LeaveCell As LeaveCellEventHandler

'Usage
 
Dim instance As FpSpread
Dim handler As LeaveCellEventHandler
 
AddHandler instance.LeaveCell, handler

public event LeaveCellEventHandler LeaveCell

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.

Property	Description
Cancel	Gets or sets whether to cancel the cell navigation.
Column	Gets the column index of the cell being left.
NewColumn	Gets the column index of the cell being entered.
NewRow	Gets the row index of the cell being entered.
Row	Gets the row index index of the cell being left.

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.

This example raises the LeaveCell event when the user leaves a cell.

C#

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!");
}

Visual Basic

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

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

FpSpread Class
FpSpread Members
LeaveCellEventArgs Class