Rutger Hendriks, I am closing the bug task for LibreOffice because the bug has been fixed in the latest development version of Ubuntu - Oneiric Ocelot.
This is a significant bug in Ubuntu. If you need a fix for the bug in previous versions of Ubuntu, please do steps 1 and 2 of the SRU Procedure [1] to bring the need to a developer's attention. [1]: https://wiki.ubuntu.com/StableReleaseUpdates#Procedure lsb_release -rd Description: Ubuntu oneiric (development branch) Release: 11.10 apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.4.2-2ubuntu3 Candidate: 1:3.4.2-2ubuntu3 Version table: *** 1:3.4.2-2ubuntu3 0 500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages 100 /var/lib/dpkg/status ** Changed in: libreoffice (Ubuntu) Status: Triaged => Fix Released -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/617264 Title: [Upstream] Calc: formulas with INDIRECT not honoring AutoCalculate Status in LibreOffice Productivity Suite: Fix Released Status in “gnumeric” package in Ubuntu: Invalid Status in “libreoffice” package in Ubuntu: Fix Released Status in “openoffice.org” package in Ubuntu: New Bug description: Binary package hint: openoffice.org Binary package hint: libreoffice 1) Natty: lsb_release -rd Description: Ubuntu Natty (development branch) Release: 11.04 Maverick: lsb_release -rd Description: Ubuntu 10.10 Release: 10.10 2) Natty: apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.1-1ubuntu5 Candidate: 1:3.3.1-1ubuntu5 Version table: *** 1:3.3.1-1ubuntu5 0 500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages 100 /var/lib/dpkg/status Maverick: apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.1-1ubuntu3~maverick1 Candidate: 1:3.3.1-1ubuntu3~maverick1 Version table: *** 1:3.3.1-1ubuntu3~maverick1 0 500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages 100 /var/lib/dpkg/status 3) What is expected to happen via the Terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/617264/+attachment/1487753/+files/Formulas%20with%20Indirect%20not%20recalculated.ods && localc -nologo Formulas\ with\ Indirect\ not\ recalculated.ods Click Tools -> Cell Contents -> AutoCalculate is checked If one puts a 1 in cell A1 then cell A3: =IF(A1="","A1 is empty",INDIRECT("'Sheet1'.B1")) automatically reflects the change. 4) What happens is it does not. WORKAROUND: Click Ctrl+Shift+F9 to get the cell with INDIRECT to calculate. Note how Gnumeric autocalculates INDIRECT function without the need for Ctrl+Shift+F9 lsb_release -rd Description: Ubuntu 10.10 Release: 10.10 apt-cache policy gnumeric gnumeric: Installed: 1.10.8-1ubuntu1 Candidate: 1.10.8-1ubuntu1 Version table: *** 1.10.8-1ubuntu1 0 500 http://us.archive.ubuntu.com/ubuntu/ maverick/universe i386 Packages 100 /var/lib/dpkg/status ProblemType: Bug DistroRelease: Ubuntu 10.04 Package: openoffice.org-core 1:3.2.0-7ubuntu4.1 ProcVersionSignature: Ubuntu 2.6.32-24.39-generic 2.6.32.15+drm33.5 Uname: Linux 2.6.32-24-generic x86_64 Architecture: amd64 Date: Fri Aug 13 10:10:28 2010 EcryptfsInUse: Yes ExecutablePath: /usr/lib/openoffice/program/soffice.bin InstallationMedia: Kubuntu 10.04 LTS "Lucid Lynx" - Release amd64 (20100427.1) ProcEnviron: PATH=(custom, no user) LANG=nl_NL.UTF-8 SHELL=/bin/bash SourcePackage: openoffice.org To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/617264/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
