<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_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Severe Bug - CALC cumputes sum wrong!"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139413">bug 139413</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>NOTABUG
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Severe Bug - CALC cumputes sum wrong!"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139413#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Severe Bug - CALC cumputes sum wrong!"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139413">bug 139413</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>Unmerge the cells. Then merge again. Note the dialog that pops up when you
merge the cells, which asks you if you want to keep the values in hidden cells,
or merge all text into one cell, or to remove it. Click "Help" button in the
dialog, which will open up
<a href="https://help.libreoffice.org/7.1/en-US/text/scalc/01/05060000.html">https://help.libreoffice.org/7.1/en-US/text/scalc/01/05060000.html</a>, telling you
that in case of "Keep the contents of the hidden cells" "the results of
formulas referring to the hidden cells will not change", which means that if a
SUM was referring the range with values, after merge those cells, even hidden,
will still be counted in the SUM.
It is a decision of spreadsheet creator to keep the values in hidden cells,
thus it's expected that the decision will affect formulas accordingly.
Closing NOTABUG.</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>