https://bugs.freedesktop.org/show_bug.cgi?id=70420
Priority: medium
Bug ID: 70420
Assignee: [email protected]
Summary: RTL: VLOOKUP() broken
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 87545
--> https://bugs.freedesktop.org/attachment.cgi?id=87545&action=edit
Said file containing said sheets
Problem description:
Hello,
the VLOOKUP() function is totally broken. It finds some words while it can't
find others that are there and clearly visible.
Find attached a file that shows the problem.
Steps to reproduce:
1. Open the attached file.
2. On the sheet called "Tabelle1" you can see different pop down menues in
column "H". The values from in rows five to 15 are taken from the "Basisdaten"
sheet cell range B115:B122.
3. In the "G" column you can see a formula that uses the VLOOKUP() function to
lookup the the value needed for the calculation. The data is looked up in the
cell range of B115:B122 from the "Basisdaten" sheet, and the function is set to
return "column" number nine. If you select "Panzerreiter" it returns the right
value but if you select "Lanzenreiter" it just seems to return nothing which is
wrong. It should return 22. As the valid data fields are the same that are used
as in the array looked at by the VLOOKUP() function it should be able to find
the names and the corresponding data.
4. The same thing happens in the "H" column from rows 18 to 38, but the lookup
valid data is taken from a different column than the data the VLOOKUP()
function uses later. In fact those values are just copied over to get a cell
range that doesn't contain invalid values and isn't interrupted. Again you
don't get anything useful back.
I can see the same problems with other sheets and other lookups.
Current behavior:
Can't find the looked up data.
Expected behavior:
Return the values found by looking up the data.
KR,
Oliver
Operating System: Mac OS X
Version: 4.1.1.2 release
--
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
