[Upstream] Calc: formulas with INDIRECT not honoring AutoCalculate

[Rutger Hendriks]

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

[penalvch (penalvch)]

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

[penalvch (penalvch)]

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!

[penalvch (penalvch)]

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

[Korrawit Pruegsanusak (detective-conan-1412)]

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!

[Rutger Hendriks (rutgerhendriks)]

Hi, the bug has indeed been fixed. Thank you all.
Op 10 sep. 2011 17:05 schreef "Christopher M. Penalver" <
<email address hidden>> 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
> Ver...

[Björn Michaelsen (bjoern-michaelsen)]

[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.