Note that only the Cell Validating event can keep the editor active,when the validation fails and it does not allow the user to exit the cell until a valid value is filled.
However, pressing the Esc key in this situation will revert the initial value of the cell and it will close the editor. The Row Validating event has a slightly different behavior.
An adaptive detail row contains the Form widget defining the layout of row items.
When implementing the event handler, you can access the Form options using the form Options field of the handler's parameter.
Instead, you can use the on Cell Click option to handle the event.
The Data Bound Item will be updated only if the cell is validated.For example, to identify whether a cell has been hovered over or hovered out, check the value of the event Type field.The index of the row to which the prepared cell belongs.In this current situation, there is only one column. If he enters some unique value in there, the row gets validated and all works well.
If he enters a duplicate value, in the You are in fact correct.
At this point the user is not allowed to cancel the performed changes, pressing the Esc key.