https://bugs.documentfoundation.org/show_bug.cgi?id=120744
Bug ID: 120744
Summary: link to external data does not work when named range
of cells containing linked formulas
Product: LibreOffice
Version: 6.1.2.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: edmund.laugas...@gmail.com
Description:
when named range of cells containing linked formulas from other sheets then
#REF! will be displayed instead of linked data
Steps to Reproduce:
1. create an .ods file with formulas that contain both linked and direct data
2. add name to range of cells both linked and direct data
3. add externally linked data to separate sheet both linked and direct data
Actual Results:
Formulas are overwritten with absolute path and therefore named cell range with
linked data does not work anymore - formulas will be broken.
Expected Results:
Formulas are NOT overwritten and named cell range with linked data works like
cell range with non-linked data. When data is located in same file there is no
point to use absolute path in formulas if it is the same file. Possibly there
could be the choice "Sheet->Link to internal data..." where I can choose named
range cell(s) in same file - that seems to be solve such issue.
Reproducible: Always
User Profile Reset: No
Additional Info:
When adding external linked data, also dead links are created with no element.
Actually
https://help.libreoffice.org/6.1/en-US/text/shared/01/02180000.html?System=UNIX&DbPAR=CALC#bm_id48899801
says that Element means "Lists the application (if known) that last saved the
source file" but this is not true. The Element is actually the named cell range
that has been used when external data link was created. Later I can change that
named cell range by choosing "Edit->Links to External Files..." and after
selecting appropriate line, click Modify... button and there is possible to
change "Available Tables/Ranges" what are exactly those named range of cells.
So - please fix also help text.
In addition "Edit->Links to External Files..." shows dead link with no Element
referred. Possibly also such dead links are causing issue(s).
In addition while opening such file, the warning message "Automatic update of
external links has been disabled" will be displayed. When trying to click
"Enable Content" then message "The following external file could not be loaded.
Data linked from this file did not get updated" and then gives full path to
file, e.g. file:///home/student/testing/bug-link-to-external-data.ods and only
choice is OK button. At the same time all data is updated as needed. Randomly
it shows #REF! and then again not in tab "autorefresh-linked".
Actually before I click "Enable", I see #REF! and after that warning message
"The following external file could not be loaded. Data linked from this file
did not get updated" when I click "Enable Content", I suddenly see linked data
properly.
When repeatedly opened the file - I did not even need to click "Enable Content"
- formulas worked even with linked data. But occasionally there are #REF! on
sheet "autorefresh-linked".
At the same time "Tools->Options->LibreOffice Calc->General->Update links when
opening->Always (from trusted locations)" was selected but did not have effect
for "Automatic update of external links has been disabled" message.
--
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
