Confirmed on Kubuntu 7.10 OOo 2.3.0 Not only a named-range problem though. Even with a "normal" =SUM() formula the col/row range isn't updated. When you actually do the insert on the row above the row with the formula (inserting a row anywhere within the range, except a new last one), the range gets updated, but then you have a gap in the table.
I find this bug extreemly important because this is not expected and easy overseen, with possible (financial) consequences for the user who is using OOo for (professional) calculations/analyzing/reporting. -- Natural named range not updated https://bugs.launchpad.net/bugs/46055 You received this bug notification because you are a member of Ubuntu Bugs, which is a direct subscriber. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs