<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Double negation with text in array context behaves like single -"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124454#c9">Comment # 9</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Double negation with text in array context behaves like single -"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124454">bug 124454</a>
from <span class="vcard"><a class="email" href="mailto:dursojohn@gmail.com" title="dursojohn@gmail.com">dursojohn@gmail.com</a>
</span></b>
<pre>It appears Excel & Google Sheets treat "--" differently than Calc.
As others have stated, Since "--" is actually a common way to convert texts to
numbers, and is taught in a lot of "Excel tips and tricks" kind of books, this
makes using Calc looking like it is calculating (to the norms) but not
calculating to what is expected.
Therefore, either 1) there should be a warning when "--" is used that this
calculates differently than the expected (at least on the first calculation of
the spreadsheet) or 2) Calc should calculate the same as Excel and Google
Sheets.</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>