[Libreoffice-bugs] [Bug 118878] weird behaviour in formulas

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Jul 22 09:08:40 UTC 2018


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

Elmar <roberg at iafrica.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |UNCONFIRMED
         Resolution|NOTABUG                     |---

--- Comment #3 from Elmar <roberg at iafrica.com> ---
If a cellA1 has 64 (number in it) and I do a compare If(A1>"64","6S","??") it
does not work even though strictly speaking, there should be no difference
between number 64 and text 64.

Maybe a solution is to report an error when one is comparing a text string with
a numeric value (number) in a cell.

What do you think?

-- 
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/20180722/7661ef64/attachment.html>


More information about the Libreoffice-bugs mailing list