Do you only get these exceptions when in debug mode, and with the debugger set to break on all exceptions? If so, you can ignore them, they will go unnoticed at runtime in release mode, and the value in the cell should revert back to the previous value when the user navigates away from it.
You can also handle the ValidationError event, in which you will be able to intervene, e.g. keep the cell in edit mode, so the user must change the value or press “ESC” to be able leave the cell.
Imported from legacy forums. Posted by André (had 249 views)