Issue 127667 - LANG=de_DE: numerical data from database are spoiled
Summary: LANG=de_DE: numerical data from database are spoiled
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.2.0-dev
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2018-01-18 23:51 UTC by Don Lewis
Modified: 2018-01-18 23:51 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


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