[jaunty] Lookup Function - No array capability

[rogerboivin]

Fixed in OOo 3.0.0

---

Binary package hint: openoffice.org

Translating a spreadsheet from excel. Several error 504 traced to the lookup function. LOOKUP in Microsoft Excel the function returns a value from a one row or one column range or an ARRAY.

In Open Office, the ARRAY capability is not supported.

ProblemType: Bug
Architecture: i386
Date: Thu Jun 19 14:29:49 2008
DistroRelease: Ubuntu 8.04
Package: openoffice.org-core 1:2.4.1-1ubuntu1
PackageArchitecture: i386
ProcEnviron:
 PATH=/usr/lib/openoffice/program:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.24-19-generic i686

[rogerboivin (rboivin)]

LOOKUP (B69,$a$4:$B$24,$C$4:$C$24)*B77 returns err 504

If I change $A$4:$B$24 to $A$4:$A$24 it no longer returns err 504

[Chris Cheney (ccheney)]

This bug appears to be fixed upstream in OOo 3.0.0m24, and a 3.0 release candidate should be in Intrepid for Alpha 4.

Thanks,

Chris Cheney