Thanks Timo, I believe it is an OpenOffice bug. I am still using 9.10 version, I just upgrade when necessary since my pc's are in production. Anyway, your procedure it works OK following your steps in OpenOffice.
BUT: If you start in Sheet1 selecting rows 1:5 instead (from first row). Then following all other steps: a) delete rows 1:5; b) check sheet2, OK. The formula in cell A1 remap the parameters =SUM(Sheet1.B6:B7) c) UNDO d) result: sheet1 is back to normal but sheet2 cell A1 shows 11 and formula IS =SUM(Sheet1.B6:B7) (should be the original =SUM(Sheet1.B2:B7)). I am using OpenOffice 3.1.1 . I used the exact file you have linked in your mail. Can you please test it the same way I did before I change to other Office package? Qui, 2011-04-21 às 17:17 +0000, Christopher M. Penalver escreveu: > 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 [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
