Start Building Professional
Web Apps Today

German number formatting

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

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 )