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