https://bugs.documentfoundation.org/show_bug.cgi?id=143116
--- Comment #6 from Elmar <rob...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
