The problem is confirmed fixed in Libreoffice 3.6.2. However Ubuntu Quantal has 1:3.6.1~rc2-1ubuntu5.
As a result this not fixed in Ubuntu until Kohei Yoshida's patch is applied. Ferry -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1061163 Title: PIVOTTABLE from Datasource (Base, Query) shows wrong results Status in LibreOffice Productivity Suite: Fix Released Status in “libreoffice” package in Ubuntu: New Bug description: Problem: Making a Pivot Table from Datasource Query gives wrong result. BUT using the _same_ data_ from the spreadsheet works correclly. How to reproduce: See upstream https://bugs.freedesktop.org/show_bug.cgi?id=53640 I just tested Kubuntu Quantal beta from virtualbox to find this bug present. This beta contains LibO 1:3.6.1~rc2-1ubuntu5 where I found the bug still present. However a fix exists for 3.6.1 see upstream comment #20. For us this bug has big implication, because we pull time/billing info from our database and use data pilot to group/format it into our invoices. As this is so important to us (to earn money) this is always the first thing I test with a new version. It actually tests the whole chain of postgresql driver, base and calc data pilots. Sadly this will block us from moving to Quantal soon, unless Quantal final releases with 3.6.2. Or backports the patch to 3.6.1. Ferry To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1061163/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
