>From upstream bugzilla comment 1: > This one has alrady been fixed on master as part of the fix for Bug 31939. > The fix will appear in 3.4 and 3.3.2. This should be fixed in 3.3.2 release in natty a few months ago, and should be fixed in oneiric too (see version number in https://launchpad.net/df-libreoffice/+packages) but the janitor doesn't work because there is no mentions to this bug in the changelog.
Anyway, I've tested version 1:3.3.2-1ubuntu2~maverick1 using libreoffice ppa and it works fine (this bug is not reproducible) Thanks! -- 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 : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
