ColumnControl search decimal formatting (fr) problem

ColumnControl search decimal formatting (fr) problem

ooiooooioo 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

  • allanallan Posts: 65,162Questions: 1Answers: 10,796 Site admin

    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

  • ooiooooioo Posts: 26Questions: 4Answers: 0

    In fact it just take the comma as a thousand separator (en) and not a decimal separator (fr).

  • ooiooooioo Posts: 26Questions: 4Answers: 0

    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

  • allanallan Posts: 65,162Questions: 1Answers: 10,796 Site admin

    Excellent - thank you. I'll look into this.

    Allan

Sign In or Register to comment.