<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - trivial sum() bad value"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116104#c9">Comment # 9</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - 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:fabrizio@bzimage.it" title="Fabrizio <fabrizio@bzimage.it>"> <span class="fn">Fabrizio</span></a>
</span></b>
<pre>Note that the <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=140250" name="attach_140250" title="doc exported from google doc">attachment 140250</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=140250&action=edit" title="doc exported from google doc">[details]</a></span> shows the right sum(). However the formula of
the sum have strange value (also in the original google doc is so):
=sum(D3:25)
and not
=sum(D3:D25)
as expected. This was a typo of the original doc in google.
However, when this is exported to opendoc it becomes:
=sum(D3:Z25)
and Z is introduced. That still show right value. But when i manually changed
to expected formula:
=sum(D3:D25)
it shows the bad value, and have no possibility to understand what's wrong:
this is the bug i think.
Try to do it.</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>