input/output/format of number-cells doesn't respect current locale

[GoogleCodeExporter]

What steps will reproduce the problem?
1. set Format to cell with german locale: Utils.setDataFormat(worksheet, new 
Rect(currentCell, currentRow, currentCell, currentRow), 
"#,##0.###############"); 
2. type or set some numbers in german format: 19, 1234, 5678,123, 1234567, 
1234567,89
3.

What is the expected output? What do you see instead?
19 => .19,  expected: 19
1234 => 1.234,  expected: 1.234
5678,123 => 5.678,123  expected: the same
1234567 => 1.234.567,  expected: 1.234.567
123456,89 => 1.234.567,89  expected: the same

What version of the product are you using? On what operating system?
2.0.1, windows xp

Please provide any additional information below.

Original issue reported on code.google.com by stephan....@apinso.com on 10 Mar 2011 at 9:01

[GoogleCodeExporter]

Per the Excel behavior(US Locale):

19 -> 19.
1234 -> 1,234.
5678.123 -> 5,678.123
1234567 -> 1,234,567.
1234567.89 -> 1,234,567.89

In German locale shall be like this

19 -> 19,
1234 -> 1.234,
5678,123 -> 5.678,123
1234567 -> 1.234.567,
1234567,89 -> 1.234.567,89

Original comment by chenhe...@gmail.com on 21 Mar 2011 at 6:34

[GoogleCodeExporter]

Fixed since Mar. 21, 2011.
--
getEditText() and setEditText() shall respect current Locale.

Original comment by chenhe...@gmail.com on 22 Mar 2011 at 2:49

• Changed title: input/output/format of number-cells doesn't respect current locale
• Changed state: Fixed