[Libreoffice-bugs] [Bug 135718] LOOKUP function stopped working

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=135718

--- Comment #3 from matevz.langus at borea.si <matevz.langus at borea.si> ---
Created attachment 167711
  --> https://bugs.documentfoundation.org/attachment.cgi?id=167711&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201201/93d55cc0/attachment.htm>