[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Bernard <bht237 at gmail.com> ---
Now I have a different situation, much easier:

1) I open an old spreadsheet with many DDE formulas that do actually work.
2) I click on the dialog "Automatic update of external links has been disabled.
[Enable Content] [X]"
2) I copy from one cell in that sheet a working DDE formula to the clipboard.
3) I create a new sheet
4) I paste the formula into that sheet.

The DDE formula breaks in the new sheet. This does not make sense to me. It is
as simple as it gets.

I suspect that the problem may come from the fact that I did not somehow enable
"Automatic update of external links" in the new sheet. I don't get that dialog. 

If I save the sheet and re-open it, then I get the dialog and the formula
works.

So getting this dialog seems to be essential.

-- 
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/20191001/a03e9a43/attachment.html>