Following the syntax for INDIRECT from http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_INDIRECT_function this is reproduced in Ubuntu 10.10 LibreOffice Calc at 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, cell A3 does not reflect this. One must click Ctrl+Shift+F9 to get the cell with INDIRECT to calculate. lsb_release -rd Description: Ubuntu 10.10 Release: 10.10 sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.0-1maverick1 Candidate: 1:3.3.0-1maverick1 Version table: *** 1:3.3.0-1maverick1 0 500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages 100 /var/lib/dpkg/status ** Also affects: libreoffice (Ubuntu) Importance: Undecided Status: New ** Tags added: lo33 ** Summary changed: - Openoffice calc: formulas with INDIRECT are not recalculated when source cells change + Calc: formulas with INDIRECT not honoring AutoCalculate -- 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
