Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | 'Lookup' function: Ranges cannot be defined by two named cells | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | jeoslislo <jeoslislo> | ||||
Component: | code | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | ace_dent, eric.bachard, issues | ||||
Version: | OOo 2.0.3 | Keywords: | ms_interoperability, oooqa | ||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
jeoslislo
2006-09-18 00:40:16 UTC
Issue Invalid. Wrong IssueZilla : we are OpenOffice.org 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
Created attachment 39209 [details]
demo excel file
>'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
Re-opening issue. Cheers. one for requirements |