<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:gtimur@gmail.com" title="Timur <gtimur@gmail.com>"> <span class="fn">Timur</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WONTFIX - LibreOffice Calc occasionally shows wrong additions."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122601">bug 122601</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;">Resolution</td>
<td>---
</td>
<td>WONTFIX
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Assignee</td>
<td>ebwegner@arcor.de
</td>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<td style="text-align:right;">See Also</td>
<td>
</td>
<td>https://bugs.documentfoundation.org/show_bug.cgi?id=107930, https://bugs.documentfoundation.org/show_bug.cgi?id=107929
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WONTFIX - LibreOffice Calc occasionally shows wrong additions."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122601#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WONTFIX - LibreOffice Calc occasionally shows wrong additions."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122601">bug 122601</a>
from <span class="vcard"><a class="email" href="mailto:gtimur@gmail.com" title="Timur <gtimur@gmail.com>"> <span class="fn">Timur</span></a>
</span></b>
<pre>Eberhard, please do not submit new bug for already reported issue like this Bug
119448.
Also:
If reporting bug, do not put Dropbox and Drive links, but attach files.
Do not zip it, but attach original.
Do not say: Actual Results: wrong / Expected Results: correct but explain
exactly what is actual and expected and where.
Do not set Assignee to yourself, it's for developer.
But prior to all, search for existing bugs and help - keyword is
"recalculation".
Raghu, this is your first message ever. Are you a developer? If yes, you can
take this bug. Generally you may submit a code. But since we have Eike's
comment here please explain first what's your expected solution.
As for the bug:
There are many similar cases. Underlying problem is that developers decided not
to recalculate all the time on each fileopen. See <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WONTFIX - Calc: set "Prompt user" as default for "Recalculation on file load""
href="show_bug.cgi?id=107929">Bug 107929</a> and <a class="bz_bug_link
bz_status_NEW "
title="NEW - Help needs to be corrected and amended for Recalculation"
href="show_bug.cgi?id=107930">Bug 107930</a>.
According to that, in attached ODS problem is not that it's now opened wrong
(up to master 6.3+) but that cached values are saved wrong.
And we don't know exactly how they were created, LO? which version? and how the
problem arose in the first place. Just see <a class="bz_bug_link
bz_status_NEW "
title="NEW - After cut/paste, cells with absolute references are not recalculated; displayed results are wrong until manual recalc performed"
href="show_bug.cgi?id=120013">Bug 120013</a> what may be the reason.
So for "fileopen" as reported, this is WontFix (because cached value is wrong
and LO will not recalculate by default).
My personal solution is given in <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WONTFIX - Calc: set "Prompt user" as default for "Recalculation on file load""
href="show_bug.cgi?id=107929">Bug 107929</a> and reporter may use it.
If we (and here I mean "reporter") discover what's the exact cause of wrong
saving value, first time it doesn't looks good, we may consider this a valid
bug.
Meaning: recalculate all and keep working until wrong value appears, then
report what exactly you did.</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>