Equal to filter condition for numeric column

Tags: #<Tag:0x00007efc72f53aa0>
#1

I’m trying to use the equal to filter for a numeric column. In this scenario, I have a numeric column and some of the rows has the data of 34.00 In the table they show up as 34, which is fine.
When I try to filter that column using “equal to” condition with value 34. It doesn’t show the row.
image
image

I think the reason for this is that the equal to condition does not take into account the fact that the column is a numeric and it just does a equal string compare which in this case is why its not showing the row with value 34.00 because it is not “string equal” to 34. Where as if the condition was 34.00 == 34. I think it would match
image

My question is, is there a way to override the default functionality of the equal to condition so that I can take into account that a column is numeric?

#2

Hi @wade.parker

I am testing Handsontable v 8.3.2 here https://jsfiddle.net/handsoncode/9n0x6v8u/ and both strings and numbers are equally treated within the 'Is equal to' filter for data defined as ‘numeric’.

Please tell me how to replicate the same issue as you experience.

#3

I’m closing this issue as there is no feedback for nearly a month.
If you still need any guidance, please create a new ticket or message me at support@handsontable.com

#4