Public bug reported: Binary package hint: openoffice.org
Ubuntu 9.10 OpenOffice 3.1.1 Spreadsheet with lookups using named ranges is not auto recalculating Tools / Cell Contents / Autocalculate is checked. The spreadsheet was created originally in Excel 2003 formulas noticed: =IF(ISBLANK(A7),"",VLOOKUP(A7,OFFSET(Volunteer,0,2,COUNTA(INDEX(Volunteer,,1)),2),2)) & =IF(ISBLANK(A6),"",VLOOKUP(A6,OFFSET(Attendee,0,2,COUNTA(INDEX(Attendee,,1)),2),2,FALSE())) However, the simple formula on the same sheet does recalculate =CONCATENATE(A5," ",B5) ProblemType: Bug Architecture: i386 CheckboxSubmission: c055b8fe69a8a63ce7a36a0829d97c26 CheckboxSystem: f134069bba098730d27f59b402920826 Date: Tue Jan 26 14:01:53 2010 DistroRelease: Ubuntu 9.10 InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release i386 (20091028.5) Package: openoffice.org-core 1:3.1.1-5ubuntu1 [modified: var/lib/openoffice/basis3.1/program/services.rdb] ProcEnviron: PATH=(custom, no user) LANG=en_GB.UTF-8 SHELL=/bin/bash ProcVersionSignature: Ubuntu 2.6.31-17.54-generic SourcePackage: openoffice.org Uname: Linux 2.6.31-17-generic i686 ** Affects: openoffice.org (Ubuntu) Importance: Undecided Status: New ** Tags: apport-bug i386 -- OpenOffice 3.1.1 spreadsheet won't auto recalculate https://bugs.launchpad.net/bugs/512797 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