Clear cell if invalid

Getting help Questions
1

Hi, i do trying to clear a cell after cell filled with invalid data.

Do try to use a hook afterValidate and change value of the cell to null if validator return false for validation.
This that i do use:

afterValidate: function (isValid, value,row,prop, source) {
if (isValid == false) {
hot.selectCell(row, prop);
hot.setDataAtCell(row, prop, null,source);
}
}

Code is partly works, but after setDataAtCell set a value for a cell fire again afterValidate hook and already return true value and clearing cell do not happen.

How to do that right way, or maybe use some another hook for this (and how check a validity then)?

Thank you.

2

Hi @korolenko

I’ve changed it a little bit Handsontable example - JSFiddle - Code Playground
(you do not need the line with selectCell.

You can test it on column Year - it accepts only digits.

3

Yeah, in your example it works. But in my code it doesn’t. And in your code it is stop working if remove data tag from initialization. The point is, i need empty cell without populated data with numeric validation which is clearing if user type in that field not a numeric value. The field is not a date. Just a numeric field.

columns: [{
data: ‘car’
}, {
data: ‘year’,
type: 'numeric’
}, {
data: ‘price_usd’,
type: ‘numeric’,
format: ‘$0,0.00’,
language: ‘en-US’
}, {
data: ‘price_eur’,
type: ‘numeric’,
format: ‘0,0.00 $’,
language: ‘de-DE’
}]
});

Change for:

columns: [{
data: ‘car’
}, {

type: 'numeric’
}, {
data: ‘price_usd’,
type: ‘numeric’,
format: ‘$0,0.00’,
language: ‘en-US’
}, {
data: ‘price_eur’,
type: ‘numeric’,
format: ‘0,0.00 $’,
language: ‘de-DE’
}]
});

I hope i did explain better, sorry for additional questions.

4

Sorry for a delay @korolenko I dd not receive a notification. Have you tried to find the issue or moved further with the project?