Hugo Cid, this issue is unreproducible via Ubuntu 10.10, LibreOffice Calc via the Terminal:
cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/608961/+attachment/2080035/+files/example.ods && localc -nologo example.ods In Sheet 1 highlight rows 2 through 5 -> click Edit -> Delete Cells -> Delete entire row(s) radio button -> OK button Notice Sheet 2, Cell A1 has: =SUM(Sheet1.B2:B3) click Edit -> Undo and notice Sheet 2, Cell A1 has: =SUM(Sheet1.B2:B7) Does this work for you? sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc lsb_release -rd Description: Ubuntu 10.10 Release: 10.10 apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.2-1ubuntu2~maverick1 Candidate: 1:3.3.2-1ubuntu2~maverick1 Version table: *** 1:3.3.2-1ubuntu2~maverick1 0 500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages 100 /var/lib/dpkg/status ** Changed in: openoffice.org (Ubuntu) Status: Expired => Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/608961 Title: undo does not recover formula of other after deleting lines -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
