Edit numeric field as per decimal/thousand separator settings
Edit numeric field as per decimal/thousand separator settings
Hi,
I am implementing DataTables and Editor plugin using javascript/jQuery in our CRM system. We have some columns which has input of type 'number'. User can set decimal separator and thousand separator in system settings as per his wish so that all numbers in the grid must be displayed and edited in that format. Say that user has set thousand separator as "." (dot) and decimal separator as "," (comma). I am able to display number in user's format but when it comes to editing the numbers I am not able to do so. As soon as I try to edit number which is displayed in user's format (like 1.234,56) it is getting converted to default format (1234.56).
- Is there anyway that I could retain the number in user's format while editing as well?
- What happens after I edit number in the user's format? Can DataTable interpret/parse the number by itself based on thousand and decimal separator that we have used?
Please find the below sample code which highlights the issue.
Replies
You'd need to set it to be "text" rather than a number input.
456,00
is exactly the same as456
. The decimal places of00
have no meaning. If it was01
then they would.The other option is to use the Masked input plug-in which could be configured as you need.
Allan
Hi Allan,
Thanks for the update.
That's what we thought of doing (changing the input type to text). But I was under assumption that as we are providing decimal and thousand separators, Datatables should somehow parse the number based on separators (and I was wrong ).
Thanks again
Deb
Unfortunately not. I did actually have an idea about this when replying above which I've noted down as a future enhancement (automatic detection of the browser's locale settings), but at the moment the thousands and decimal separator options are for DataTables only and not Editor which just uses HTML5 inputs.
Allan