<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 - Err:522 on updating data from linked sheet"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127024">127024</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Err:522 on updating data from linked sheet
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.0.4 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>dwmw2@infradead.org
</td>
</tr></table>
<p>
<div>
<pre>On updating to LibreOffice 6.3.0.4 I see a regression with a spreadsheet which
was also the subject of <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - some cell formulas not updated after linked files update (need hard recalc)"
href="show_bug.cgi?id=86978">bug 86978</a>.
Upon opening the sheet I see a banner saying that automatic update of external
links has been disabled. At this point, cell G11 ('Shares in' for Child A) is
showing correct data.
I click 'Enable Content', and the fund prices are updated from the nearby CSV
file. Now cell G11 says 'Err:522'.
I click to edit cell G11. I add a space after the formula and hit enter. Now it
works again.
This was working OK until today, when I updated to LO 6.3.0.4. Not yet sure
precisely which version I had before; this is Ubuntu 18.04.
This problem doesn't seem to occur with the cut-down repro in <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - some cell formulas not updated after linked files update (need hard recalc)"
href="show_bug.cgi?id=86978">bug 86978</a>; I'll
work on a new repro or perhaps just provide the real one in private on request.
The interesting thing to note about cell G11 is that it's the first cell where
there is a manual payment to child B's account. So cell F11 contains "" because
the date column A11 contains a manually entered date, and the ISFORMULA() check
in column D notes that it is not an automatic monthly payment.
If I change the formula in cell G11 to just:
=IF($A11<>"",G10,"")
Then save and reopen the spreadsheet and allow the data to update, then
everything works fine.
If I change it to this:
=IF(F11<>"",F11+G10,"B")
the problem still doesn't recur after reload+update (although obviously things
aren't working right from row 11 down now).
Change it back to what it should be:
=IF(F10<>"",F10+G9,IF($A10<>"",G9,""))
and the problem recurs.
Setting cell D11 manually to zero does make the Err:522 go away and the correct
result appear, temporarily, but the problem recurs after reload+update.
Ctrl-Shift-F9 does not make the problem go away. Highlighting the offending
cell and hitting F9 on it does.
There is a later row where Child B received a payment but child A did not. That
one is not affected.</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>