[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

--- Comment #18 from Edmund Laugasson <edmund.laugasson at gmail.com> ---
Sorry about complex formulas but these work and this is not the issue. If you
look closer then I just solved the issue with random errors when people write
names incorrectly, containing accidental non-relevant symbols. Also I solved an
issue to generate strong passwords randomly. This table was necessary just to
fix collected names and generate appropriate e-mail addresses with passwords
for .csv file for users bulk creation. That file was born when two of the
IT-managers from my community sent a request that can I solve such tasks with
LibreOffice Calc like fix entered names with accidentally entered inappropriate
symbols and generate usable e-mail addresses with strong passwords.
As I mentioned - this is not a simple, comfortable bug. Using one task with
fixed names and generated e-mails, passwords for another task to offer an
automatic refresh. As passwords are generated randomly then this was a good way
to prove that auto refresh actually works when you see these values
continuously renewing.

> That observation is not correct. The formula *displays* the absolute path (as always for external URIs).

Please see there are different files. One is working properly, another not
(with #REF!)

> 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.

This setting is relative by default. But links will appear with absolute path
that will give #REF! values. Sounds like that setting is not working.

> 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.

Could not find another way to automatically refresh table on another screen.
There was requirement from my community to solve the issue and that is what I
found.

> 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.

That is done in first file (27.46 KB .ods) where autorefreshing works.

In that sense I am confused - why I am getting #REF! When to compare the files
where autorefresh works and file where it does not work then formulas are same.
If you claim this is not a bug but feature then I am totally confused.

-- 
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/20190219/d42449d0/attachment.html>