<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:gunther.lenz@quergedacht.at" title="Gunther Lenz <gunther.lenz@quergedacht.at>"> <span class="fn">Gunther Lenz</span></a>
</span> changed
<a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Empty cells have non-zero value when used in formula(hard recalc needed)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=89404">bug 89404</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;">Status</td>
<td>RESOLVED
</td>
<td>REOPENED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>WORKSFORME
</td>
<td>---
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Empty cells have non-zero value when used in formula(hard recalc needed)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=89404#c13">Comment # 13</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Empty cells have non-zero value when used in formula(hard recalc needed)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=89404">bug 89404</a>
from <span class="vcard"><a class="email" href="mailto:gunther.lenz@quergedacht.at" title="Gunther Lenz <gunther.lenz@quergedacht.at>"> <span class="fn">Gunther Lenz</span></a>
</span></b>
<pre>After loading loo-empty-cell-bug.ods contains the worng values.
Neither F9 nor Ctrl-F9 work for me. :(
Tried it on
Version: 5.2.6.2
Build-ID: a3100ed2409ebf1c212f5048fbe377c281438fdc
CPU-Threads: 4; BS-Version: Windows 6.2; UI-Render: Standard;
Gebietsschema: de-DE (de_DE); Calc: group
and also on
Version: 5.3.3.2
Build-ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448
CPU-Threads: 4; BS-Version: Windows 6.2; UI-Render: Standard; Layout-Engine:
neu;
Gebietsschema: de-DE (de_DE); Calc: group
----
But this works:
As soon as I enter a Value in ONE of the cells in column B ALL cells in column
E are updated correctly.</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>