Comment 0 for bug 381543
Revision history for this message
| Kieran Fleming (kieran-fleming) wrote OpenOffice Calc VLOOKUP function doesn't work like Excel | #0 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0f7b58d
(Get the code!)
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