Posted 9 February 2022, 7:02 pm EST
In Spread.NET in an ASP.NET MVC 5 application, we are trying to fix a problem where, when saving a spreadsheet, if the last edited cell is still focussed, the change is not registered, and does not get saved with it’s last given value.
We have partly fixed this by use of the EditStart and EditStopped events on cells, disabling/enabling the save button, and checking if the callback is finished.
However, when we use dropdowns (of the ComboBoxCellType), the EditStart/Stopped does not get triggered, resulting in the previous problem persisting (when going from dropdown value 1 to 2, and saving without leaving the cell, the change is not registered).
In our case, the dropdown box is always required to be shown, so we set the ShowButton property of the ComboBoxCellType to true.
Is there any solution to this problem you can offer us?
With regards, Brian