https://bugs.documentfoundation.org/show_bug.cgi?id=120744
--- Comment #18 from Edmund Laugasson <edmund.laugas...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
