<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - link to external data does not work when named range of cells containing linked formulas" href="https://bugs.documentfoundation.org/show_bug.cgi?id=120744#c18">Comment # 18</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - link to external data does not work when named range of cells containing linked formulas" href="https://bugs.documentfoundation.org/show_bug.cgi?id=120744">bug 120744</a> from <a class="email" href="mailto:edmund.laugasson@gmail.com" title="Edmund Laugasson <edmund.laugasson@gmail.com>"> Edmund Laugasson</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>