[Libreoffice-bugs] [Bug 120744] link to external data does not work when named range of cells containing linked formulas

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com

--- Comment #17 from Eike Rathke <erack at redhat.com> ---
(In reply to Edmund Laugasson from comment #0)
> Actual Results:
> Formulas are overwritten with absolute path and therefore named cell range
> with linked data does not work anymore - formulas will be broken.
That observation is not correct. The formula *displays* the absolute path (as
always for external URIs). Whether subsequently loading a file will take an
absolute or a relative URI depends on the settings when saving the file, Tools
-> Options -> Load/Save -> General, Save URLs relative to file system.

I don't understand even why you are trying to link an "external" file that is
not an external file but the very same document and have each link reload every
second. Doing so might ask for trouble, yes, though in general it should be
handled generously. For referencing data in the same document on a different
sheet simply use 3D references such as $Sheet1.A1 or named ranges, either
global or sheet scope level.

-- 
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/20190218/bac5d3cb/attachment.html>