[Bug 239774] Re: Subtotal function not summing correct when using autofilter

2008-10-22 Thread maansson
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 cor

[Bug 239774] Re: Subtotal function not summing correct when using autofilter

2008-07-24 Thread maansson
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 's

[Bug 239774] Re: Subtotal function not summing correct when using autofilter

2008-06-13 Thread maansson
** 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

[Bug 239774] [NEW] Subtotal function not summing correct when using autofilter

2008-06-13 Thread maansson
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.