Bug 218314 - editors/openoffice-4: LANG=de_DE: numerical data from database are spoiled
Summary: editors/openoffice-4: LANG=de_DE: numerical data from database are spoiled
Status: Open
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: amd64 Any
: --- Affects Some People
Assignee: Don Lewis
URL: https://bz.apache.org/ooo/show_bug.cg...
Depends on:
Reported: 2017-04-03 06:23 UTC by Dr. Andreas Haakh
Modified: 2018-01-18 23:57 UTC (History)
1 user (show)

See Also:


Note You need to log in before you can comment on or make changes to this bug.
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.