Issue 69621 - 'Lookup' function: Ranges cannot be defined by two named cells
Summary: 'Lookup' function: Ranges cannot be defined by two named cells
Status: CONFIRMED
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:
URL:
Keywords: ms_interoperability, oooqa
Depends on:
Blocks:
 
Reported: 2006-09-18 00:40 UTC by jeoslislo
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
demo excel file (5.50 KB, application/vnd.ms-excel)
2006-09-18 12:59 UTC, jeoslislo 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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 
=LOOKUP(A6;a_start:a_end;b_start:b_end)

where a and b are tables,

which works fine in Excel

gives this error:

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

Wrong IssueZilla : we are OpenOffice.org
Comment 2 ace_dent 2006-09-18 07:57:39 UTC 
Not wishing to contradict 'ericb', but this may effect OpenOffice.org.
>'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...

Regards,
Andrew
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,
Andrew
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