https://issues.apache.org/ooo/show_bug.cgi?id=125804
Issue ID: 125804
Issue Type: DEFECT
Summary: Calc Lookup is broken
Product: Calc
Version: 4.1.0
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: ui
Assignee: [email protected]
Reporter: [email protected]
Created attachment 84118
--> https://issues.apache.org/ooo/attachment.cgi?id=84118&action=edit
lookup-different-sheet-odd-behavior
A couple other issues appear to have been reported: 44554, confirmed. IT IS AN
ISSUE. Not sure how that can be CLOSED, NOT_AN_ISSUE, when it is.
Lookups are broken when on another page. I have attached an example of a simple
LOOKUP. Haven't verified for other range-based functions, but I imagine the
behavior may be similar.
Basically, you have to specify an additional cell in the lookup and result
vectors when on another sheet. On the same sheet, oddly, not an issue.
Assessment is this: should also not be an issue on another sheet, but it is.
Again, see attached.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
