https://bugs.documentfoundation.org/show_bug.cgi?id=101988
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |ASSIGNED
Assignee|[email protected] |[email protected]
|desktop.org |
--- Comment #15 from Eike Rathke <[email protected]> ---
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
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
