Confirmed on upstream's OOo 3.0m24.
** Changed in: openoffice.org (Ubuntu)
Importance: Undecided => Low
Status: New => Triaged
** Also affects: openoffice
Importance: Undecided
Status: New
** Changed in: openoffice
Status: New => Invalid
--
lookup() fails with words
I should have read the documention myself, it is intentional behavior:
"
LOOKUP
Returns the contents of a cell either from a one-row or one-column range.
Optionally, the assigned value (of the same index) is returned in a different
column and row. As opposed to VLOOKUP and HLOOKUP, search and re
** Attachment added: "Two Worksheets with Lookup() failures"
http://launchpadlibrarian.net/15871448/Lookup_Fails.ods
--
lookup() fails with words or non-alphabetical arrays
https://bugs.launchpad.net/bugs/246279
You received this bug notification because you are a member of Ubuntu
Bugs, which