German number formatting

Discontinued products Uncategorized discussions
#1

Hello,



I need an input field for numerical values in the German format. Example: 123.456,789.



If I use setNumberFormat(“0,000.000”, QuantityColNbr, “,”, “.”). I get the following result:



1. Input 123456,789, result 123456,000. The decimal places are cut off and filled in with 0.



2. Input 123456.789, result 123456,789. Input is not in german format. Result is OK…





If I use setNumberFormat (“0,000.000”, QuantityColNbr, “.”, “,”). I get the following result:



1. Input 123456,789, result 123,456.000. The decimal places are cut off. Number of US formats.



2. Input 123456.789, result 123,456.789.



How I get the desired result. Example: Input 123456,789 and result 123.456,789 .



Thanks in advance and best regards



Rolf

#2

The incoming data must be in javascript compatible format.Such data as “123456,789” will be parsed by javascript as “123456” it will not recognize part after comma which ill result in error.
If you provide data as
123456.789
and use
setNumberFormat(“0,000.000”, QuantityColNbr, “,”, “.”).
it will result in
123.456,789

( Technically it possible to add custom logic to onCellChanged event and use any custom logic to format values in necessary way )