https://bugs.freedesktop.org/show_bug.cgi?id=70420
Priority: medium Bug ID: 70420 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: RTL: VLOOKUP() broken Severity: normal Classification: Unclassified OS: Mac OS X (All) Reporter: grime...@gmx.net 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs