<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - : sum function omits one value from list, add two values includes it"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133893#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - : sum function omits one value from list, add two values includes it"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133893">bug 133893</a>
from <span class="vcard"><a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> <span class="fn">m.a.riosv</span></a>
</span></b>
<pre>(In reply to Mark Fielden from <a href="show_bug.cgi?id=133893#c3">comment #3</a>)
<span class="quote">> To me it is a bug.
> The problem is inconsistent operation.
> a) all the numbers were entered into the text document in the same way</span >
Maybe
รง
<span class="quote">> b) the SUM function omitted one of the values without reporting an error</span >
Because at least for me it is a text with dot as decimal separator.
What kind of error should be reported?
<span class="quote">> c) the add function accumulated all the values correctly</span >
Because only with direct references calc tries to convert numeric text in
values when there are no ambiguity.
<span class="quote">> d) if the user hadn't thought the SUM total wrong, he could have made a bad
> decision</span >
Like any other stuff users needs to know how to use the tools, and at the
contrary that it is a way to avoid a number being taking in account.
Use the right arrow on the paste button or go through paste special and paste
as non formatted selecting the proper options to get the right values pasted.</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>