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

Eike Rathke <er...@redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |ASSIGNED
           Assignee|libreoffice-b...@lists.free |er...@redhat.com
                   |desktop.org                 |

--- Comment #15 from Eike Rathke <er...@redhat.com> ---
Can simply be reproduced with a hard recalc Shift+Ctrl+F9 or by changing any
value in Vrange or Drange or editing the formula expression.

Though unrelated to this "" empty string lookup, note that the search vector
for LOOKUP must be sorted in ascending order, otherwise the function may
deliver meaningless arbitrary results. This is also true for OpenOffice and
probably Excel as well.

As for the "" empty string lookup, that should sort between the largest numeric
value and any other string so the largest numeric value should be matched in
this case IF the range was sorted properly.

I'll investigate.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to