<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - enhancement request: better handling of outdated cached values | notabug: file was saved with outdated values | was: 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;">Severity</td>
<td>normal
</td>
<td>enhancement
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>DUPLICATE
</td>
</tr>
<tr>
<td style="text-align:right;">Version</td>
<td>6.0.7.3 release
</td>
<td>4.1.6.2 release
</td>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>sum error when opening an xlsx in Calc
</td>
<td>enhancement request: better handling of outdated cached values | notabug: file was saved with outdated values | was: sum error when opening an xlsx in Calc
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>newbie-02@gmx.de
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - enhancement request: better handling of outdated cached values | notabug: file was saved with outdated values | was: sum error when opening an xlsx in Calc"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130698#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - enhancement request: better handling of outdated cached values | notabug: file was saved with outdated values | was: 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:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span></b>
<pre>i think in the history of the table data was added or updated while
'autocalculate' was off, the following work to identify the the error (row
31++) did not trigger a recalculation of row 30 ...
funnily hard recalc can't heal the deviation in cols V:Y ... the formulas in
row 30 start from row 6 instead of row 5,
<span class="quote">> checked in MS Excel, does not have same problem</span >
probably recalculate on load active in excel?
<span class="quote">> integrity test when one opens a spreadsheet which was not created by Calc</span >
won't be save, same problem can easily be constructed in calc,
<span class="quote">> version: checked back until 4.1.6.2, </span >
automatic 'recalc' always stays in the balancing act trying to avoid errors
(with) or delays (without),
thus:
enhancement request to inform users when dealing with outdated cached values
...
*** This bug has been marked as a duplicate of <a class="bz_bug_link
bz_status_NEW "
title="NEW - enhancement request: better handling of outdated cached values | notabug: file was saved with outdated values | was: error in calculating sums"
href="show_bug.cgi?id=130118">bug 130118</a> ***</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>