<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - calc: #REF! error condition not evaluated for dependent cells, needs recalc, autocalculate failure"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131339">131339</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>calc: #REF! error condition not evaluated for dependent cells, needs recalc, autocalculate failure
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.8.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>newbie-02@gmx.de
</td>
</tr></table>
<p>
<div>
<pre>Description:
an error condition injected in the head of a dependecy chain is (sometimes in
distinct situations) not evaluated for dependent cells, it needs any recalc to
apply to the dependent cells, autocalculate doesn't handle. bug maybe older, i
observed it in 7.0.0.0.a0+ and tested 6.2.8.2 to be buggy too.
on a quick check: it looks as if only errors injected above the dependent cells
are critical, similar constructions at the left, right or bottom border worked
ok.
Steps to Reproduce:
minimum reproducer:
0. fresh sheet,
1. put '=B1' into B2,
2. observe B2 showing '0' - correct,
3. copy B2 - ctrl-c,
4. paste into B1 - ctrl-v,
5. observe B1 showing #REF! or err:522 - correct,
6. observe B2 still showing '0' - incorrect,
7. whenever a cell gets an error condition making it 'uncalculateable' all
dependency chains should inherit that and switch to err too, that insn't
respected for B2 in this case,
7a. it is! respected for - at least some - other error conditions, e.g.
changing B1 to '=0/0' or deleting row 1 instead of implementing error formulae,
Actual Results:
dependent cells (B2 in this case) don't inherit #REF! or err:522 error
conditions from upstream cells,
Expected Results:
error condition handed over to dependent cells,
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.0.0.0.alpha0+ (x64)
Build ID: 9ed75e2c65544b4f71c73e1c51a68d74e31d544b
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win;
Locale: de-DE (de_DE); UI-Language: en-US
Calc:</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>