** Description changed:
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
+ 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
-
- 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
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 11.04
+ Release: 11.04
+
+ 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
** Also affects: gnumeric (Ubuntu)
Importance: Undecided
Status: New
** Changed in: gnumeric (Ubuntu)
Status: New => Invalid
** Description changed:
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 11.04
- Release: 11.04
+ 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
+ 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
--
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
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
