<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> <span class="fn">Winfried Donkers</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTOURBUG - trivial sum() bad value"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116104">bug 116104</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTOURBUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTOURBUG - trivial sum() bad value"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116104#c14">Comment # 14</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTOURBUG - trivial sum() bad value"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116104">bug 116104</a>
from <span class="vcard"><a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> <span class="fn">Winfried Donkers</span></a>
</span></b>
<pre>When investigating the the document internally, like raal did in <a href="show_bug.cgi?id=116104#c12">comment#12</a>, it
becomes apparent that the document itself is at fault, not Calc. This is a
document created by Google Docs (see <a href="show_bug.cgi?id=116104#c7">comment#7</a>), not by Calc.
Proper ODF documents contain a reference to the application which created/saved
the document, this document does not contain any such reference, so I can't see
which application/version exactly was used to save the document.
The formulas in the documents are saved incorrectly, with the result that they
appear as formulas, but do not work as such.
It can be demonstrated by recalculating the formulas: select any cell with a
formula (=something) and press F9. Now you see the correct result of the
formula.
For cells D4, D7, D9, D10, D11 and D23 the result seems to be a realignment
from left to right, but in reality it is a change from text (incorrect) to
numeric value (correct). For cell D26, the change is twofold: a change from
text to numeric value and a recalculation with a different value as result
(depending on whether D4, D7, D9, D10, D11 or D23 have been recalculated).
I cannot explain why the formulas in D5 and D6 are saved correctly in the
document.
As my conclusion is that Google Docs created a faulty document, it a Google bug
and not a Calc bug. Setting the status as such.</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>