Issue 127667

Summary:	LANG=de_DE: numerical data from database are spoiled
Product:	Calc	Reporter:	Don Lewis <truckman>
Component:	editing	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P5 (lowest)
Version:	4.2.0-dev
Target Milestone:	---
Hardware:	All
OS:	All
URL:	https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=218314
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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.