Public bug reported:
Binary package hint: openoffice.org
When using the VLOOKUP function, the second parameter is interpreted as an
array in OpenOffice, but Excel treats it as a range. This means that Excel
spreadsheets that use a single cell reference will work in Excel, but not in
OpenOffice. It should be possible to fix this by treating a single cell
reference as a single element array.
Test case attached.
ProblemType: Bug
Architecture: amd64
DistroRelease: Ubuntu 9.04
Package: openoffice.org-core 1:3.0.1-9ubuntu3
ProcEnviron:
PATH=(custom, no user)
LANG=en_AU.UTF-8
SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.28-11-generic x86_64
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug
--
OpenOffice Calc VLOOKUP function doesn't work like Excel
https://bugs.launchpad.net/bugs/381543
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
