ColumnControl search decimal formatting (fr) problem
ColumnControl search decimal formatting (fr) problem
ooioo
Posts: 26Questions: 4Answers: 0
Hi,
I am using ColumnControl (1.1.0 with Bootstrap 5) 'search'.
It is working fine except for columns containing decimal values, formatted in french with a comma as separator for the decimal part (ex: 13,5).
Datatables recognizes that the column contains numeric (proposing '>', '>="...) but when typing values in search input no lines are found.
Strings, int and dates are working fine.
Thanks,
Pierre.
Replies
Hi Pierre,
Good point - thank you. I don't attempt to change the format from the input to what the computer sees as a decimal. I'll add it to my list.
It would be useful if you could link to a test case showing the problem please.
Thanks,
Allan
In fact it just take the comma as a thousand separator (en) and not a decimal separator (fr).
Test case :
https://live.datatables.net/fasihite/1/edit?html,js,console,output
Salaire = 1,33 : no data
Salaire > 1,33 : idem
Salaire > 1.33 : all lines
Excellent - thank you. I'll look into this.
Allan