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

Eike Rathke <er...@redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |er...@redhat.com

--- Comment #17 from Eike Rathke <er...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to