[Bug 239774] Re: Subtotal function not summing correct when using autofilter
Still a problem in 11.04. This should be seen as a critical issue. Thanks -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/239774 Title: Subtotal function not summing correct when using autofilter -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 239774] Re: Subtotal function not summing correct when using autofilter
Issue is fixed for me. For some reason, there was a quote character (') in front of some of the numbers. This only appeared when selecting French language in the Formatting options. I used technique described in this thread to convert all the rows to number. http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=178st=0sk=tsd=astart=10#p1030 Pressing CTRL+SHFT + F9 works then recalculating the subtotals as expected. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/239774 Title: Subtotal function not summing correct when using autofilter -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 239774] Re: Subtotal function not summing correct when using autofilter
This is still a problem on 9.10. Following this guide results in a document that doesn't work as described. http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_SUBTOTAL_function Attached is an example document saved in .ods format on 9.10 with a single formula. Most people switching from Excel are not trying to use the rocket science functionality available in OpenOffice - they just need the basics to work. I can't believe that such simple things that stop ordinary people from using OpenOffice have not been addressed yet - after YEARS. If bug #1 if ever going to be addressed, we need to start by getting some of the basics right first! ** Attachment added: Sample document where SUBTOTAL function doesnt work http://launchpadlibrarian.net/40899621/subtotal_broken.ods -- Subtotal function not summing correct when using autofilter https://bugs.launchpad.net/bugs/239774 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 239774] Re: Subtotal function not summing correct when using autofilter
I confirm this bug for Ubuntu 9.10 with OpenOffice-Calc 3.1.1. Neither automatic recalculation of the function 'subtotal' nor manuall recalc with F9 works. -- Subtotal function not summing correct when using autofilter https://bugs.launchpad.net/bugs/239774 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 239774] Re: Subtotal function not summing correct when using autofilter
Confirmed here with Hardy and OO version 1:3.0.1-1ubuntu1. As Fabio XXL wrote, subtotal(9;range) works only if applied after the autofilter. It doesn't update if the filter is changed afterwards. Same behavior actually with other values of function for subtotal(function;range) -- Subtotal function not summing correct when using autofilter https://bugs.launchpad.net/bugs/239774 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 239774] Re: Subtotal function not summing correct when using autofilter
Hi there, I'm facing the same problem with the subtotal(9;range) function in all my spreadsheet. I have tried the the suggested fix also using the attached test file and doesn't work. The only way to have the subtotal function to work it's to modify it after apply the filter choice... The package version is: openoffice.org-core 1:2.4.1-1ubuntu2.1 Do you have any suggestion about what to check more? Uname: 2.6.24-21-server #1 SMP DISTRIB_ID=Ubuntu DISTRIB_RELEASE=8.04 DISTRIB_CODENAME=hardy DISTRIB_DESCRIPTION=Ubuntu 8.04.2 -- Subtotal function not summing correct when using autofilter https://bugs.launchpad.net/bugs/239774 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 239774] Re: Subtotal function not summing correct when using autofilter
Hi Chris, I can confirm that your described solution solved the problem. I'm sure that your suggested fix did not work when I submitted the bug also because I was able to reconstruct the error in the example I attached (which is not my original file). Is it possible that another update has corrected the bug? - and thanks! Best regards, Troels -- Subtotal function not summing correct when using autofilter https://bugs.launchpad.net/bugs/239774 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 239774] Re: Subtotal function not summing correct when using autofilter
Yes, probably the underlying bug was fixed at some point but the older version of OpenOffice.org must have created slightly invalid files, so when updating the autofilter it now works. :-) Thanks! Chris ** Changed in: openoffice.org (Ubuntu) Status: Incomplete = Fix Released -- Subtotal function not summing correct when using autofilter https://bugs.launchpad.net/bugs/239774 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 239774] Re: Subtotal function not summing correct when using autofilter
The file seems to be somehow messed up? I reapplied the autofilter (Data-Filter-Autofilter) to the top row again and it works fine for me. Can you see if that fixes the problem for you? Thanks, Chris Cheney ** Changed in: openoffice.org (Ubuntu) Status: Confirmed = Incomplete -- Subtotal function not summing correct when using autofilter https://bugs.launchpad.net/bugs/239774 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 239774] Re: Subtotal function not summing correct when using autofilter
I replied to the e-mail with detail - sorry I missed that I had to do it here. The subtotal function is supposed to only sum lines visible making it possible to use it in combination with autofilter. I've attached an example (use the autofilter dropdowns) using the two functions 'subtotal' and 'sum' which in this case always (incorrectly) gives the same results. Further information and examples of the subtotals function can be seen here: http://www.openofficetips.com/blog/archives/2005/03/basic_functions_9.html ** Attachment added: subtotal example.ods http://launchpadlibrarian.net/16277015/subtotal%20example.ods ** Changed in: openoffice.org (Ubuntu) Status: Invalid = New -- Subtotal function not summing correct when using autofilter https://bugs.launchpad.net/bugs/239774 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 239774] Re: Subtotal function not summing correct when using autofilter
** Changed in: openoffice.org (Ubuntu) Status: New = Confirmed -- Subtotal function not summing correct when using autofilter https://bugs.launchpad.net/bugs/239774 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 239774] Re: Subtotal function not summing correct when using autofilter
We are closing this bug report because it lacks the information we need to investigate the problem, as described in the previous comments. Please reopen it if you can give us the missing information, and don't hesitate to submit bug reports in the future. To reopen the bug report you can click on the current status, under the Status column, and change the Status back to New. Thanks again! ** Changed in: openoffice.org (Ubuntu) Status: Incomplete = Invalid -- Subtotal function not summing correct when using autofilter https://bugs.launchpad.net/bugs/239774 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 239774] Re: Subtotal function not summing correct when using autofilter
Thank you for taking the time to report this bug and helping to make Ubuntu better. I've seen the behavior you are talking about but I am not familiar with what this particular function should do. What behavior do you expect? Thanks in advance. ** Changed in: openoffice.org (Ubuntu) Status: New = Incomplete -- Subtotal function not summing correct when using autofilter https://bugs.launchpad.net/bugs/239774 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 239774] Re: Subtotal function not summing correct when using autofilter
** Attachment added: Dependencies.txt http://launchpadlibrarian.net/15263376/Dependencies.txt -- Subtotal function not summing correct when using autofilter https://bugs.launchpad.net/bugs/239774 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs