Detecting Lost Focus to commit changes

The spreadsheet lost focus event doesnt seem to be the one to use or it doesnt fire when I'm expecting it to.

Hi Spotty, 

Thanks for using Syncfusion product. 

By default, If cell is in edit mode, focus will not loss until you commit the value using press the enter key or navigate to next cell. This is the excel behavior.  To achieve your reported scenario, you could implement the custom cell renderer for SpreadsheetTextBoxCellRenderer and override the OnEditElementLostFocus method. Please refer the following code example and the sample. 

VB 

AddHandler Me.spreadsheet.WorkbookLoaded, AddressOf Spreadsheet_WorkbookLoaded    Private Sub Spreadsheet_WorkbookLoaded(ByVal sender As Object, ByVal args As Syncfusion.Windows.Forms.Spreadsheet.Helpers.WorkbookLoadedEventArgs)      Me.spreadsheet.ActiveGrid.CellRenderers("TextBox") = New CustomTextBoxCellRenderer()  End Sub    Partial Class CustomTextBoxCellRenderer      Inherits Syncfusion.Windows.Forms.Spreadsheet.CellRenderer.SpreadsheetTextBoxCellRenderer      Public Sub New()      End Sub        Protected Overrides Sub OnEditElementLostFocus(sender As Object, e As EventArgs)          MyBase.OnEditElementLostFocus(sender, e)          'To commit the cell value.          Me.Grid.CurrentCell.EndEdit()      End Sub  End Class

 

 

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/VB-363891025  

 

Please get back to us if you need any further assistance on this. 

Regards, 

Arulraj A 

The code same works when I click out of dropdown to another cell in the spreadsheet but not when I click on a control outside of the sheet - when I also want to commit the edit prior to carrying out the action. 

Hi Spotty,  

 

Thanks for your update. 

 

The reported scenario is default excel behavior. If you use the ComboBox column for cell, the cell values will not commit until click on any cell. So, we can’t change this behavior. Please find the following excel video demo link 

 

Video demo: http://www.syncfusion.com/downloads/support/directtrac/general/ze/TestedDemo-1111111507  

 

Please get back to us if you need any further assistance on this. 

 

Regards, 

Mohanraj G