Getting the callback false count in cell using validator in Handsontable

Tags: #<Tag:0x00007efc6d6385d8>
#1

I am trying to get the callback(false) count. Is there any option that I can find the error cell at end

Method I used:

validator: function (value, callback) {
if (value>20) {
callback(false);
Seterrorcounter=Seterrorcounter+1;
}

I used counter to count the error , but if I rectify the error cell with correct data, I still get the same count

#2

Hi @vedaselvaraj27

Do you mean something like this https://jsfiddle.net/handsoncode/xu2rf6tn/ would be the desired outcome?

#3

@aleksandra_budnik

Using this https://jsfiddle.net/handsoncode/xu2rf6tn/

Test Case :

1.In Row 0, Set Year as 201 --> Output : 1
2.In Row 1, Set Year as 207 --> Output : 2
3.In Row 0, Set Year as 2 --> Output : 2
4.In Row 1, Set Year as 5 --> Output : 2

What I expect :
1.In Row 0, Set Year as 201 --> Output : 1
2.In Row 1, Set Year as 207 --> Output : 2
3.In Row 0, Set Year as 2 --> Output : No Error / 0 (All cell are in correct format)
4.In Row 1, Set Year as 5 --> Output : No Error / 0 (All cell are in correct format)

#4

In step.3. the cell (1,1) still has the 207 defined, so I guess that the output should be 1, and in step 4. the output is 0.

If so, you can run through the column to check which cells are invalid. I do this by afterValidate hook to make sure that all the cells have been validated https://jsfiddle.net/handsoncode/u27wgxfL/

#5

Hi @aleksandra_budnik

Yes, In step3 output should be 1, I made a mistake while prep testcase

Thank you so much , It worked like a charm

#6

Thank you for the confirmation. I’m glad I could help.

#7