[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
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
** 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
[Bug 239774] [NEW] Subtotal function not summing correct when using autofilter
Public bug reported: Binary package hint: openoffice.org Subtotal(9;range) does not adjust the sum according to autofilters - works exactly like a standard SUM. Description:Ubuntu 8.04.1 Release:8.04.1 openoffice.org-base-core: Installed: 1:2.4.1~rc2-1ubuntu1 Candidate: 1:2.4.1~rc2-1ubuntu1 Version table: *** 1:2.4.1~rc2-1ubuntu1 0 500 http://dk.archive.ubuntu.com hardy-proposed/main Packages 100 /var/lib/dpkg/status 1:2.4.0-3ubuntu6 0 500 http://dk.archive.ubuntu.com hardy/main Packages ProblemType: Bug Architecture: i386 Date: Fri Jun 13 16:49:25 2008 DistroRelease: Ubuntu 8.04.1 NonfreeKernelModules: nvidia Package: openoffice.org-core 1:2.4.1~rc2-1ubuntu1 PackageArchitecture: i386 ProcEnviron: PATH=/usr/lib/openoffice/program:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games LANG=en_DK.UTF-8 SHELL=/bin/bash SourcePackage: openoffice.org Uname: Linux 2.6.24-19-generic i686 ** Affects: openoffice.org (Ubuntu) Importance: Undecided Status: New ** Tags: apport-bug -- 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
