https://bugs.freedesktop.org/show_bug.cgi?id=74594
Priority: medium
Bug ID: 74594
Assignee: [email protected]
Summary: Lookup function returns #N/A STILL BROKEN
Severity: blocker
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 4.2.0.4 release
Component: Libreoffice
Product: LibreOffice
Created attachment 93499
--> https://bugs.freedesktop.org/attachment.cgi?id=93499&action=edit
Examples of all bugs described
Lookup function is horribly broken and I question your QA process because of it
(but constructively as I am invested in your success). There is a lot of good
work here but if the function returns garbage and random results it calls into
question the entire suite. It is critical that you fix this as soon as
possible, correctly.
Lookup works when it wants to, then it returns #N/A randomly when it should
not, but even worse than that, it randomly returns values not related to a
match including values for non-matches.
Please note that I have found the same behavior in OpenOffice 4.0 - so its in
the older common code.
In the attached sheet you will find 7 lookup functions each identical in size
and pointing to their own range of data. They are structured as follows: Lookup
values (e.g.: cell B1, G1, L1) are provided, the function returns its result in
cell D1 (and I1, N1, D8, I8 etc).
The ranges that are looked up are under the Lookup text (example A3:A6) and the
values returned are one column to the right of that (example B3:B6).
The behaviors to test require that you enter in the lookup cell each value from
the lookup range in turn (try them all please, there are only 4 for each
example). The search result should match the related search result. For each
example, also try entering no value in the lookup field (should give a #N/A)
and try entering a value that is not found (should five a #N/A as well).
For lookups on B1, everything works as it should to find values in the range
(0-3) but a not-found value (4) returns a 0 - which is wrong.
For lookups on G1, which is the same data range values as B1 but in reverse
(3-1) values 1 and 0 return a #N/A.
For lookup on L1, the value x returns #N/A correctly but the value 6 returns 0
- it should also return a #N/A.
For lookup on B8, we use text values (a-d) instead of numbers, and everything
works. Blank values correctly return a #N/A but a not-found value returns a 0.
For lookup on G8 we just reversed the sequence on the search range (d-a), and
now a return a #N/A even though it exists. Non-existent values return a 0.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
