Rutger Hendriks, since this bug has enough information provided for a developer to begin work, I'm going to mark it as Triaged and let them handle it from here. Thanks for taking the time to make Ubuntu better!
** Description changed: Binary package hint: openoffice.org + Binary package hint: libreoffice - 1) lsb_release -rd + 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) apt-cache policy libreoffice-calc + 2) + Natty: + apt-cache policy libreoffice-calc libreoffice-calc: - Installed: 1:3.3.1-1ubuntu3~maverick1 - Candidate: 1:3.3.1-1ubuntu3~maverick1 + Installed: 1:3.3.1-1ubuntu5 + Candidate: 1:3.3.1-1ubuntu5 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 + *** 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 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 + 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 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 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 ** Changed in: libreoffice (Ubuntu) Importance: Undecided => Medium ** Changed in: libreoffice (Ubuntu) Status: New => Triaged -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/617264 Title: Calc: formulas with INDIRECT not honoring AutoCalculate -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs