<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - sum error when opening an xlsx in Calc"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130698">bug 130698</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;">CC</td>
<td>
</td>
<td>erack@redhat.com
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - sum error when opening an xlsx in Calc"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130698#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - sum error when opening an xlsx in Calc"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130698">bug 130698</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>It is reproducible with ersion: 6.4.1.1 (x64)
Build ID: 56f3c78975db08733f771c53643b5d1aa7c57567
CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: GL; VCL: win;
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: CL
It uses the cached value stored in the XLSX file:
<span class="quote">> <c r="E30" s="23" t="n">
> <f aca="false">SUM(E5:E29)</f>
> <v>454</v>
> </c></span >
It depends on the default setting "Recalculation on File Load": "Excel 2007 and
newer" - "Never recalculate" under Options->Calc->Formula. If, however, it is
set to "Always recalculate", this is expectedly shown correct. Also doing a
hard recalc on the file normalizes the calculated data. Actions in the sheet
like copy and paste to other places that don't affect the formula cell e.g. in
E30 will expectedly *not* recalculate its value, since SUM is not a volatile
function.
I don't know if this should be closed NOTABUG. Eike, what do you think?</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>