[Libreoffice-bugs] [Bug 138996] New: Are FLOSS doomed to be buggy because famous closed sources software are (just for the sake of compatibility)??

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138996
           Summary: Are FLOSS doomed to be buggy because famous closed
                    sources software are (just for the sake of
                    compatibility)??
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: sexxxenator at gmail.com

Hi,

I just stumbled into a strange behaviour in LibreOffice Calc, which returned a
false result after I evaluated a long formula. Simplifying the formula, I
discovered that the problem can be resumed to inserting "-4^2" in a cell and
getting a different results than inserting "0-4^2". I was quite astonished!!!

Looking for an explanation, I found this:
https://en.wikipedia.org/wiki/Order_of_operations#Unary_minus_sign

So in the end, the conclusion is the LibreOffice is buggy because M$ Excel is
and because Calc is trying to be as compatible as possible with M$ Excel it HAS
to be buggy.

This raised a general question: are all the FLOSS apps doomed to be buggy, just
because famous closed-source software are? For instance, should we voluntarily
introduce bugs in the Linux kernel just because Wine need to work exactly like
M$'s kernel?!??

PS: For the curious ones, the operator's precedence are (quite) well defined
mathematically, so YES Excel IS buggy (should I say "again"?):
https://www.youtube.com/watch?v=tYf3CpbqAVo [in French]
https://fr.wikipedia.org/wiki/ISO/CEI_80000-2
https://people.engr.ncsu.edu/jwilson/files/mathsigns.pdf

-- 
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/20201217/1317dd87/attachment.htm>