After editing a number value on a German system, the value displayed is 100 times what it should be in the column, but the value displayed in the editor is correct.
I have tracked this down to the following code in ig.formatter:
// keep only e, E, -, +, . and digits
val = parseFloat(val.replace('(', '-').replace(/[^0-9\-eE\.\+]/gm, ''));
Since german uses , as the decimal separator and . as the thousands separator, applying the above code to a value such as 123,45 yields a value of 12345 while a value such as 1.234,56 yields a value of 1.23456.
Hi, Karl.
Thank you for using our product and I will be glad if I can help you.
You are right that the default settings of the Currency Editor are "." for decimal separator and "," for group separator. The editor can be configured in the following manner:
$('#currencyEditor').igCurrencyEditor({
decimalSeparator: ",",
groupSeparator: "."
});
In this way you can define the separators in opposite manner - "," for decimal separator and "." for group separator. Can tell me if this works for you? I will wait for your feedback and if you have any further questions don't hesitate to ask me.
Best regards, Nikolay Alipiev