Hi, the bug has indeed been fixed. Thank you all. Op 10 sep. 2011 17:05 schreef "Christopher M. Penalver" < [email protected]> het volgende: > 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 subscribed to the bug > report. > 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
-- 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: [Upstream] Calc: formulas with INDIRECT not honoring AutoCalculate To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/617264/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
