I have a data grid within a reactive web app that writes back changes to the underlying table on an OnCellChangeEvent. The process works correctly except when the user clears out the cell via backspace without clicking into the cell, the OnCellChangeEvent is not triggered. This is confirmed through the black change mark staying on the row and the old value appearing after clicking the refresh button. This doesn’t occur in the number columns because they can’t be blank.

My main two issues.

1. Why does the OnCellChangeEvent not trigger when the cell is cleared out via backspace without clicking into the cell (clicking delete works fine) ?
   1. Is my only option somehow disabling the ability to clear the cell via backspace?
2. How can I allow a number column value to be blank? When I backspace or delete nothing changes. I tried changing the IsMandatory to False but nothing changed. The reason I use a number column is because I need to remove the thousands separator from the number.

I attached an OML file example. Thank you in advance.