[This is an automated message.] There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix
If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already. Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination. -- 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: Won't Fix 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
