Launchpad has imported 30 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=53640.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2012-08-17T10:33:13+00:00 Rado-tsvetkov wrote: Created attachment 65688 Screenshot Problem: Making a Pivot Table from Datasource Query gives wrong result. BUT using the _same_ data_ from the spreadsheet works correclly. How to reproduce: 1. Use Datasource from Base Query or use the rpovided file and Query 2012-Analysis-Query" 2. Make the Pivot Table using that query with Columns "Month", Row "Activity" and Data field "Time" 3. Import the same data to a spreadsheet, select and make the same Pivot Table. the results are different and the Pivot TAble from the Data source is wrong! See the attached screenshot for all details! Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/0 ------------------------------------------------------------------------ On 2012-08-17T10:39:36+00:00 Rado-tsvetkov wrote: Created attachment 65689 Used Databese and Speadsheet PLS register the Datasource in the office before refreshing the range! Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/1 ------------------------------------------------------------------------ On 2012-08-17T11:58:36+00:00 Rado-tsvetkov wrote: This bug is not existent in LibreOffice 3.4.6 OOO340m1 (Build:602) Debian squeeze Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/2 ------------------------------------------------------------------------ On 2012-08-21T14:27:36+00:00 Iplaw67 wrote: *** Bug 53656 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/3 ------------------------------------------------------------------------ On 2012-08-21T14:29:23+00:00 Iplaw67 wrote: @Lionel : your area if its a DB filter problem, or Kohei's or Markus' for Calc ? Alex Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/4 ------------------------------------------------------------------------ On 2012-08-21T14:40:23+00:00 Kohei Yoshida wrote: As an aside, I hope people stop over-using ! at the end of sentences. I interpret that to be yelling, and I prefer not to be yelled at. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/5 ------------------------------------------------------------------------ On 2012-08-21T14:44:44+00:00 Iplaw67 wrote: Also confirmed on : Version 3.7.0.0.alpha0+ (Build ID: 9e04ae0) master build from 21/08 Alex Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/6 ------------------------------------------------------------------------ On 2012-08-21T14:50:28+00:00 Lionel Elie Mamane wrote: (In reply to comment #4) > @Lionel : your area if its a DB filter problem, or Kohei's or Markus' for Calc I can easily believe it is my area, but I am completely swamped. It would be helpful if "somebody else" took care of it, or at least pointed me at the exact problem within connectivity and/or dbaccess modules. I'm available for "technical support" concerning database stuff. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/7 ------------------------------------------------------------------------ On 2012-08-21T14:51:10+00:00 Lionel Elie Mamane wrote: (In reply to comment #7) > I'm available for "technical support" concerning database stuff. I meant "technical support to the person handling / fixing this bug", obviously. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/8 ------------------------------------------------------------------------ On 2012-08-21T18:11:15+00:00 Kohei Yoshida wrote: I'll take a look, and give it back to you if the problem is not on the calc side. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/9 ------------------------------------------------------------------------ On 2012-08-22T14:59:04+00:00 Libreoffice-z wrote: Already broken with - Server Installation of "LibreOffice 3.6.0beta1 German UI/Locale [Build-ID: 1f1cdd8] on German WIN7 Home Premium (64bit) Data still was correct with - Server installation of Master "LOdev 3.6.0alpha0+ – WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 475d0c5-829fc92-39746e8-206648e-fefd87]" (2012-02-14) Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/10 ------------------------------------------------------------------------ On 2012-08-22T18:16:42+00:00 Kohei Yoshida wrote: Aha! Turns out that this was a simple human error on the calc side. I'll fix it soon. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/11 ------------------------------------------------------------------------ On 2012-08-22T19:02:28+00:00 Libreoffice-bugs wrote: Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f4ed9a5adbea3de88870ff4f5cb202bd606e0746 fdo#53640: Correctly cache source data coming from database backend. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/12 ------------------------------------------------------------------------ On 2012-08-22T19:07:29+00:00 Kohei Yoshida wrote: Sorry Rainer. I accidentally reverted your change. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/13 ------------------------------------------------------------------------ On 2012-08-22T19:25:09+00:00 Libreoffice-bugs wrote: Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a28d9cad672739cbf8dc6cf1f9db7d0f8becfee1&g=libreoffice-3-6 fdo#53640: Correctly cache source data coming from database backend. It will be available in LibreOffice 3.6.2. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/14 ------------------------------------------------------------------------ On 2012-08-23T00:28:27+00:00 Kohei Yoshida wrote: I call this fixed. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/15 ------------------------------------------------------------------------ On 2012-08-23T07:32:49+00:00 Tim Passingham wrote: I'd just like to say that as an ordinary user I'm most impressed by the speed with which this has been investigated & fixed. Thanks to all involved. I look forward to getting 3.6.2 in October. This is as good a demonstration of the justification for my (and hopefully many others) recent move away from Windows and MS Office as I could wish for. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/16 ------------------------------------------------------------------------ On 2012-08-23T08:34:06+00:00 Michael Meeks wrote: Hi Tim, > I'd just like to say that as an ordinary user I'm most impressed by the speed > with which this has been investigated & fixed. Thanks to all involved. > I look forward to getting 3.6.2 in October. Thanks for your encouragement - it means a lot ! Having said that - it would really help to find these bugs earlier - have you considered testing pre-release builds ? eg. http://www.libreoffice.org/download/pre-releases/ Or - even better running direct from tinderbox builds of master: http://dev-builds.libreoffice.org/daily/ If you can find new regressions in those master builds that are not in the last release (and there are often some), it's fair-game to mail the developers directly at [email protected] so we can tighten the cycle of bug creation to fixing, improve the final product, and build a relationship with the developers :-) And thanks to Rado for a quick, clean bug report ! Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/17 ------------------------------------------------------------------------ On 2012-08-23T08:52:01+00:00 Tim Passingham wrote: Unfortunately I am mostly limited to 1 PC for both using and testing libreoffice, so testing pre-release versions is not really practical since I need calc, base & writer to work reasonably well. I am, however, prepared to move to new full release versions fairly early even if not 100% stable, as I did with 3.6, and then back off if I have to. I'll move on as soon as is practical. I reported this problem at 53656 shortly after this report was raised. My report turned out to be a duplicate - I'm not sure how I missed this one. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/18 ------------------------------------------------------------------------ On 2012-08-23T15:29:45+00:00 Rado-tsvetkov wrote: 10x Great work cowboys :) I'll be happy to retest, but after a week of holidays. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/19 ------------------------------------------------------------------------ On 2012-08-27T20:48:43+00:00 Libreoffice-bugs wrote: Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-3-6-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7ca2d95c8ee30c450483433d5f380ebbf80691d5&g=libreoffice-3-6-1 fdo#53640: Correctly cache source data coming from database backend. It will be available already in LibreOffice 3.6.1. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/20 ------------------------------------------------------------------------ On 2012-08-29T13:08:22+00:00 Tim Passingham wrote: Forgive me for asking, I am somewhat inexperienced in these matters with open software. Is this fix in 3.6.1 as released on 29/8/12 or not? I see it is declared above as being in 3.6.1, but is it really? I cannot see it in http://download.documentfoundation.org/libreoffice/src/bugfixes- libreoffice-3-6-1-release-3.6.1.2.log or http://www.mirrorservice.org/sites/download.documentfoundation.org/tdf/libreoffice/src /bugfixes-libreoffice-3-6-1-release-3.6.1.1.log I would like to try the fix, but it would take me several hours (and several opportunities for me to screw up) to download, install, test and revert to 3.5 if I have to. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/21 ------------------------------------------------------------------------ On 2012-08-29T13:10:21+00:00 Kohei Yoshida wrote: (In reply to comment #21) > Forgive me for asking, I am somewhat inexperienced in these matters with open > software. > > Is this fix in 3.6.1 as released on 29/8/12 or not? I see it is declared above > as being in 3.6.1, but is it really? No it's not. There's been some confusion between us devs and the release schedule, and it was committed to the 3.6.1 branch *after* the GA of 3.6.1 release. It will be available in 3.6.2. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/22 ------------------------------------------------------------------------ On 2012-08-29T13:18:02+00:00 Tim Passingham wrote: Thanks very much for your speedy response. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/23 ------------------------------------------------------------------------ On 2012-09-10T09:45:55+00:00 Rado-tsvetkov wrote: Verified - fixed in 3.7.0 alpha 0 2012-09-09 12.46.31 daily build Win Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/24 ------------------------------------------------------------------------ On 2012-10-03T16:30:58+00:00 Ferry Toth wrote: 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. For us this bug has big implication, because we pull time/billing info from our database and use data pilot to group/format it to 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 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/25 ------------------------------------------------------------------------ On 2012-10-03T16:42:36+00:00 Tim Passingham wrote: My understanding is that this is fixed in 3.6.2, due for final release this week. I intend to test it for my own use on 12.04 as soon as it can be downloaded. If you want to test a beta it is already available as 3.6.2 RC2. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/26 ------------------------------------------------------------------------ On 2012-10-04T09:02:06+00:00 Michael Meeks wrote: Ferry: it'd be great to test your fix in the pre-releases: http://www.libreoffice.org/download/pre-releases/ or vs. master: http://dev-builds.libreoffice.org/daily/ To verify the fix; though we release 3.6.2 today which should make things easier :-) Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/28 ------------------------------------------------------------------------ On 2012-10-04T16:21:30+00:00 Ferry Toth wrote: Michael, I'll be happy to test the fix in 3.6.2 rc, beta or final on windows. I'm just afraid that Ubuntu Quantal will ship with 3.6.1 without the fix. BTW it is not my fix, see comment #20. Ferry Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/29 ------------------------------------------------------------------------ On 2012-10-04T16:55:26+00:00 Tim Passingham wrote: I have just run 3.6.2 on ubuntu 12.04. The problem is fixed. Thanks to all. Now I just have to find out how to make ubuntu/unity make the new version the default. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1061163/comments/30 ** Changed in: df-libreoffice Status: Unknown => Fix Released ** Changed in: df-libreoffice Importance: Unknown => High -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1061163 Title: PIVOTTABLE from Datasource (Base, Query) shows wrong results To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1061163/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
