Comment 0 for bug 381543

Revision history for this message
Kieran Fleming (kieran-fleming) wrote : OpenOffice Calc VLOOKUP function doesn't work like Excel

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