Download it now!
Bug 121472 - Link to cell in external document doesn't work (wrong file URL)
Summary: Link to cell in external document doesn't work (wrong file URL)
Status: RESOLVED DUPLICATE of bug 76047
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.6.2 release
Hardware: x86-64 (AMD64) Mac OS X (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-11-16 21:29 UTC by Michael Kallweitt
Modified: 2018-11-16 23:20 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Kallweitt 2018-11-16 21:29:38 UTC
Description:
When opening a calc document (xlsx format) containing a cell which references to another calc document, the cell won't update due to a malformed file name (URL). This is the error message:

Die folgende externe Datei konnte nicht geladen werden. Die verknüpften Daten aus dieser Datei wurden nicht aktualisiert.

file:///Users/michael/Nextcloud/Documents/Projekte/2018/Paulusviertel/Orga/Users/michael/Nextcloud/Documents/Projekte/2018/Paulusviertel/Orga/Kopie von Leerformular.xls

For some reason in the URL above, the part containing the target directory ('/Users/…/Orga') is duplicated.

Steps to Reproduce:
1. Create a Calc document with a reference to a cell in another Calc document
2. Save document in XLS format (Microsoft Excel 2007-2013 XML)
3. Close document window
4. Open previously saved document
5. Confirm request to update external values

Actual Results:
Die folgende externe Datei konnte nicht geladen werden. Die verknüpften Daten aus dieser Datei wurden nicht aktualisiert.

file:///Users/michael/Nextcloud/Documents/Projekte/2018/Paulusviertel/Orga/Users/michael/Nextcloud/Documents/Projekte/2018/Paulusviertel/Orga/Kopie von Leerformular.xls

Expected Results:
Cell values should be updated without error


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 m.a.riosv 2018-11-16 23:20:25 UTC
Looks like a dup, please if you are not agree reopen it.

*** This bug has been marked as a duplicate of bug 76047 ***