markling, thank you for reporting this bug and making Ubuntu better. In Ubuntu 10.10, libreoffice-calc performed via the Terminal:
cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/654058/+attachment/1669046/+files/test%204.ods && soffice -calc test%204.ods It is noticed how if one inserts a blank row into row 5, the equation of B6 becomes =SUM(B4+A6) One way to get what your looking for is if after inserting the blank row into row 5, highlight cells B4 through B6, click Edit -> Fill -> Down. Does this work for you? lsb_release -rd Description: Ubuntu 10.10 Release: 10.10 sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.0-1maverick1 Candidate: 1:3.3.0-1maverick1 Version table: *** 1:3.3.0-1maverick1 0 500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages 100 /var/lib/dpkg/status ** Changed in: openoffice.org (Ubuntu) Status: New => Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/654058 Title: Calc: Insert row causes error in formula below insert that referred to row above it -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
