How to stop grid from displaying NaN in cells on validation

Suite and Optimus Suite 5
#1

I have a grid that I’m using validation on.

I have cells that are supposed to only accept numeric values. The cells must also be filled in before sending data to the server.

I have a custom validation for these cells.

But when I test it by entering “foo” in the cells, the validation works but it fills the cells with “NaN” instead of just leaving the cells blank.

Is there any way to force the grid to not do this?

Thanks

#2

You may try to use the onValidationError event to change the value of the cell failed the validation:
docs.dhtmlx.com/doku.php?id=dhtm … ationerror