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