https://bugs.freedesktop.org/show_bug.cgi?id=53656
Bug #: 53656
Summary: PIVOTTABLE: Pivot tables that worked in 3.5.n fail in
3.6
Classification: Unclassified
Product: LibreOffice
Version: 3.6.0.4 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Problem description:
I have some pivot tables in Calc based on moderately complex queries on a MySQL
database, via a database registered in LibreOffice. These used to work. With
3.6 they return incorrect data. They seem to decouple the row fields from the
data fields, and report the data in purely ascending order independent of the
row field. Thus if I have data
A 20
B 10
C 15
The Pivot table now incorrectly returns
A 10
B 15
C 20
I have used MySql with JDBC, with ODBC and (in 3.5 only) the native connector
(to check if the connection method is the cause). All 3 options return the
correct data when viewed in Base in 3.5 and 3.6, and the correct data in Calc
in 3.5, but incorrect data in Calc in 3.6.
I have also used queries defined within Base itself on the MySQL database, and
views defined within MySQL. The results are the same.
I have concluded the problem, must lie in the 'enhanced' pivot tables in 3.6.
I have tried to pin down where the problem is in 3.6. I suspect, but am not
yet sure, that it may be queries with Left or Right joins that may be causing
the problems. I have a couple of straightforward pivot tables that seemed to
be OK, but all those with more complex underlying structures failed badly.
Unfortunately I need the system on my main PC to return the correct data and
have had to revert to 3.5.6. I can't easily switch between 3.5 and 3.6 to test
any hypotheses.
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Linux x86_64) Ubuntu/12.04 64 bit
Chromium/18.0.1025.168
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
