<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_NEW "
title="NEW - Redefined #REF! values recovers the last value and fórmula, however it's never updated anymore EDITING the referenced cell"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132986">bug 132986</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;">Blocks</td>
<td>
</td>
<td>109324
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Redefined #REF! values recovers the last value and fórmula, however it's never updated anymore EDITING the referenced cell"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132986#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Redefined #REF! values recovers the last value and fórmula, however it's never updated anymore EDITING the referenced cell"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132986">bug 132986</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>add. info:
references to cells below affected as well (B2: '=B3'), also 'somewhere in the
sheet' (not restricted to borders), also with some distance between reference
and referencier (D4: '=D7', but does not affect references to cells besides
(B2: '=C2'),
reference is 'dead' while input number or text into the referenced cell, but
becomes live again on input of formula, e.g. '=3' in the referenced cell will
be respected by the referencing cell,
at least with below ver. - but from memory it was on other versions too - the
cell doesn't 'cell recovers the last value and fórmula', but recovers the last
formula, and a fresh calculated '0',
Version: 7.1.0.0.alpha0+
Build ID: 20ba8d8d9f4fcf7d5826fcb3366a9bff0d6a8ca1
CPU threads: 8; OS: Linux 5.6; UI render: default; VCL: gtk3
Locale: en-US (en_US.utf8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time:
2020-06-10_07:16:41
Calc: threaded</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Calculate bugs and enhancements"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109324">Bug 109324</a>] [META] Calculate bugs and enhancements
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>