Apache OpenOffice (AOO) Bugzilla – Issue 127667
LANG=de_DE: numerical data from database are spoiled
Last modified: 2018-01-18 23:51:14 UTC
Databasetables viewed in 'Data Sources' (F4) show up correct, eg. a numerical value of 5.90 is localized as 5,90. If you include the table in a spreadsheet (Data->Pivot Table->Create), all decimal-commas are displayed as decimal-points and some values are changed to a date-format. '5,90' appears as '01.05.90'. Processing these values yield strange results. The same phenomenon exists if you replace the table by a local query or a database view. Database is postgresql94-server remotely accessed by current JDBC-driver. This problem was originally reported for the FreeBSD port of 4.1.3, but I am able to reproduce this on 4.2.0-dev on Windows.