<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - LOOKUP function stopped working" href="https://bugs.documentfoundation.org/show_bug.cgi?id=135718#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - LOOKUP function stopped working" href="https://bugs.documentfoundation.org/show_bug.cgi?id=135718">bug 135718</a> from <a class="email" href="mailto:matevz.langus@borea.si" title="matevz.langus@borea.si <matevz.langus@borea.si>"> matevz.langus@borea.si</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=167711" name="attach_167711" title="spreadsheet showing the issue">attachment 167711</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=167711&action=edit" title="spreadsheet showing the issue">[details]</a> spreadsheet showing the issue Hi, I reproduced the same error most probably. Attached file demonstrating the issue. I can confirm the reason for the problem was unsorted lookup vector. But if I exported to xslx and opened in Apple Numbers then it worked fine without any changes. So perhaps it is a bit strange that vector must be sorted after all. Being a developer it makes sense to me, but yesterday I was a secretary and in that mode of operation I did not even think sorting would be required. regards, Matevz</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>