Public bug reported:
Binary package hint: openoffice.org
Ubuntu 9.10 OpenOffice 3.1.1 Spreadsheet with lookups using named ranges
is not auto recalculating Tools / Cell Contents / Autocalculate is
checked. The spreadsheet was created originally in Excel 2003 formulas
noticed:
=IF(ISBLANK(A7),"",VLOOKUP(A7,OFFSET(Volunteer,0,2,COUNTA(INDEX(Volunteer,,1)),2),2))
&
=IF(ISBLANK(A6),"",VLOOKUP(A6,OFFSET(Attendee,0,2,COUNTA(INDEX(Attendee,,1)),2),2,FALSE()))
However, the simple formula on the same sheet does recalculate
=CONCATENATE(A5," ",B5)
ProblemType: Bug
Architecture: i386
CheckboxSubmission: c055b8fe69a8a63ce7a36a0829d97c26
CheckboxSystem: f134069bba098730d27f59b402920826
Date: Tue Jan 26 14:01:53 2010
DistroRelease: Ubuntu 9.10
InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release i386 (20091028.5)
Package: openoffice.org-core 1:3.1.1-5ubuntu1 [modified:
var/lib/openoffice/basis3.1/program/services.rdb]
ProcEnviron:
PATH=(custom, no user)
LANG=en_GB.UTF-8
SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-17.54-generic
SourcePackage: openoffice.org
Uname: Linux 2.6.31-17-generic i686
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
** Tags: apport-bug i386
--
OpenOffice 3.1.1 spreadsheet won't auto recalculate
https://bugs.launchpad.net/bugs/512797
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
