[Libreoffice-bugs] [Bug 127024] New: Err:522 on updating data from linked sheet

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127024

            Bug ID: 127024
           Summary: Err:522 on updating data from linked sheet
           Product: LibreOffice
           Version: 6.3.0.4 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dwmw2 at infradead.org

On updating to LibreOffice 6.3.0.4 I see a regression with a spreadsheet which
was also the subject of bug 86978.

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 bug 86978; 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190819/64291cf4/attachment-0001.html>