[Libreoffice-bugs] [Bug 143116] vlookup does not return results if string includes special characters

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Elmar <roberg at iafrica.com> ---
Thank you, Uwe.
I am at a loss as to how to resolve this kind of issue.
There are just so many tips and tricks based on settings and if I was not
checking and reporting, i would never have have been told about this.
It is only because I build lots of checks into sheets that I noticed there was
a problem.
my solution was to F&R the offending characters.
Had no idea that Uwe's solution was possible (partly because I have been using
spreadsheets since 1982(?) Visicalc. And so you never consider looking for
other solutions.

NOTE:
I do think that the default should be FALSE, because then at least you would
get warned (as I was that there is a problem). If "the last value that is
smaller than the criterion will be returned" then one may be operating under
the illusion that all is OK.
https://www.forbes.com/sites/timworstall/2013/02/13/microsofts-excel-might-be-the-most-dangerous-software-on-the-planet/?sh=373ae0d8633d

I consider Calc to be the most valuable tool that project manager can have.

-- 
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/20210630/507558b2/attachment.htm>