Bug 218314

Summary: editors/openoffice-4: LANG=de_DE: numerical data from database are spoiled
Product: Ports & Packages Reporter: Dr. Andreas Haakh <bugReporter>
Component: Individual Port(s)Assignee: Don Lewis <truckman>
Status: Open ---    
Severity: Affects Some People CC: truckman
Priority: ---    
Version: Latest   
Hardware: amd64   
OS: Any   
URL: https://bz.apache.org/ooo/show_bug.cgi?id=127667

Description Dr. Andreas Haakh 2017-04-03 06:23:30 UTC

Comment 1 Dr. Andreas Haakh 2017-04-03 06:55:49 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.
Comment 2 Don Lewis freebsd_committer 2018-01-18 23:45:11 UTC
This is an upstream bug.  I am able to reproduce it with the trunk version (4.2.0)  on Windows.