<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Are FLOSS doomed to be buggy because famous closed sources software are (just for the sake of compatibility)??"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138996">138996</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Are FLOSS doomed to be buggy because famous closed sources software are (just for the sake of compatibility)??
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>sexxxenator@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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:
<a href="https://en.wikipedia.org/wiki/Order_of_operations#Unary_minus_sign">https://en.wikipedia.org/wiki/Order_of_operations#Unary_minus_sign</a>
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"?):
<a href="https://www.youtube.com/watch?v=tYf3CpbqAVo">https://www.youtube.com/watch?v=tYf3CpbqAVo</a> [in French]
<a href="https://fr.wikipedia.org/wiki/ISO/CEI_80000-2">https://fr.wikipedia.org/wiki/ISO/CEI_80000-2</a>
<a href="https://people.engr.ncsu.edu/jwilson/files/mathsigns.pdf">https://people.engr.ncsu.edu/jwilson/files/mathsigns.pdf</a></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>