https://bugs.freedesktop.org/show_bug.cgi?id=71800
raal <r...@post.cz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEEDINFO Assignee|libreoffice-b...@lists.free |r...@post.cz |desktop.org | Ever confirmed|0 |1 --- Comment #6 from raal <r...@post.cz> --- Created attachment 105433 --> https://bugs.freedesktop.org/attachment.cgi?id=105433&action=edit try 2 Hello, I opened file try.ods in LO 3.4.3 . Result of LOOKUP function is 0 or empty (where data is empty or space). I repaired data ranges in your testing file. I mean this is correct, see help https://help.libreoffice.org/Calc/Spreadsheet_Functions#LOOKUP https://help.libreoffice.org/Calc/Handling_of_Empty_Cells Setting as NEEDINFO. Please test with newer version, set back to UNCONFIRMED if you find the bug, otherwise close the bug. Thank you. -- 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