Public bug reported:
Binary package hint: openoffice.org-calc
In the spreadsheet which I will attach, cells C47, C63 and C64
incorrectly show #NA instead of, respectively, 4, 6 and 6, even though
"Con" and "Cha" both appear in the lookup range. If I switch labels
around (whether in the lookup range B1:G1 or the criteria cells
C46:C64), or change the values, it is still always the values in D8 and
G8 that are incorrectly shown as #NA.
ProblemType: Bug
Architecture: i386
DistroRelease: Ubuntu 9.04
NonfreeKernelModules: nvidia
Package: openoffice.org-core 1:3.1.0-5ubuntu1~jaunty1
ProcEnviron:
PATH=(custom, no user)
LANG=en_CA.UTF-8
SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.28-13-generic i686
UnreportableReason: This is not a genuine Ubuntu package
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
** Tags: apport-bug i386
--
LOOKUP() outputs #NA incorrectly
https://bugs.launchpad.net/bugs/402765
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
