Issue 69621 - 'Lookup' function: Ranges cannot be defined by two named cells
Summary: 'Lookup' function: Ranges cannot be defined by two named cells
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability, oooqa
Depends on:
Reported: 2006-09-18 00:40 UTC by jeoslislo
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

demo excel file (5.50 KB, application/
2006-09-18 12:59 UTC, jeoslislo
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jeoslislo 2006-09-18 00:40:16 UTC

where a and b are tables,

which works fine in Excel

gives this error:

Comment 1 eric.bachard 2006-09-18 06:20:25 UTC
Issue Invalid.

Wrong IssueZilla : we are
Comment 2 ace_dent 2006-09-18 07:57:39 UTC
Not wishing to contradict 'ericb', but this may effect
>'jeoslislo', please can you attach a test document to assist in recreating your
problem. I assume you have tested the latest 'Offical' OOo Mac version- and have
recreated the problem there too...


Comment 3 jeoslislo 2006-09-18 12:59:46 UTC
Created attachment 39209 [details]
demo excel file
Comment 4 ace_dent 2006-09-18 18:20:28 UTC
>'jeoslislo', thanks for raising the issue and supplying the file.

I believe this is an OpenOffice - MS Excel incompatability.
It seems Excel will allow you to define a range for a function by two named
cells ('a_start':'a_end'). This is not supported (AFAIK) in OOo. However, you
can define a named range ('a'='a_start':'a_end').

This probably functions as designed and is thus an Enhancement.

Many thanks,
Comment 5 ace_dent 2006-09-18 18:21:46 UTC
Re-opening issue. Cheers.
Comment 6 frank 2006-09-19 10:36:18 UTC
one for requirements