Hi,
We have encountered an issue with Spreadsheet control in our application, where the Edit Mode is not exited automatically if the user clicks button outside of the DockManager which contains this Spreadsheet control in different area. As the result, the edited value in the cell is not committed/updated and the view model persists incorrect state of the workbook. We have not found another way to get an uncommitted edit value from the Spreadsheet cell.
If the button outside of DockManager is clicked, there is no EditModeExiting event fired, and there is no opportunity to get a value from edit mode. If the button is located inside of the DockManager together with Spreadsheet control, it works fine. In our case we need to make it work for button outside of the DockManager. Clicking on this button should commit save the edited value to workbook. How to make it work this button?
I have attached a sample code which reproduces the described behavior. SpreadsheetEditMode.zip
Steps to reproduce:
Thanks for suggestion. We placed this code into LostKeyboardFocus and this worked. Having same in LostFocus method this did not worked. What's the difference between these two events?