Eike Rathke <> changed:

           What    |Removed                     |Added
             Status|REOPENED                    |ASSIGNED
           Assignee| |
                   |                 |

--- Comment #15 from Eike Rathke <> ---
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

Reply via email to