In my previous question, I was able to achieve what I want which is to manually set a cell’s border color to red if the data is invalid. I’m using my own validator and not using the validator setting inside column. Thanks for your help, guys.
So,since I’m using my own validator on the fly, and I was already able to apply red border to the cell if the data is invalid. What I want to achieve now is this:
- For example the user, double clicks a cell, and change data from
- Obviously, my custom validator would output an error coz that is not a valid email
- So I would mark that current cell as invalid and apply red border to it
- This is the part which I want to ask: how can I prevent default events (default behavior after pressing Enter is that it would go to next cell, right?) and just stay on that current invalid cell.
So that’s my goal for now. If that cell is still invalid, the user cannot click (single or double click or edit) another cell. It will stay on that current invalid cell until the user types in a valid data.
After a valid data is typed in, it will revert back to normal. I hope my explanation is clear.
Thanks for the time!