[Bug 246279] Re: lookup() fails with words or non-alphabetical arrays

2008-07-17 Thread Chris Cheney
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

[Bug 246279] Re: lookup() fails with words or non-alphabetical arrays

2008-07-17 Thread Chris Cheney
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

[Bug 246279] Re: lookup() fails with words or non-alphabetical arrays

2008-07-07 Thread Amanda Bee
** 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