Bug 90299 - External links don't saved as relative in xls
Summary: External links don't saved as relative in xls
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: All All
: high normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls
Depends on:
Blocks: XLS
  Show dependency treegraph
 
Reported: 2015-03-28 17:56 UTC by geeker
Modified: 2019-03-24 12:06 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
example files (13.05 KB, application/x-7z-compressed)
2015-03-28 17:56 UTC, geeker
Details
test with 4.4.1.2 (320.39 KB, image/jpeg)
2015-03-30 16:48 UTC, geeker
Details

Note You need to log in before you can comment on or make changes to this bug.
Description geeker 2015-03-28 17:56:03 UTC
Created attachment 114420 [details]
example files

When saving the .xls spreadsheet external links are not stored as relative. If file is moved external links not update nor in the LO or in MSO. 
When you open the spreadsheet created in MSO external links updating succeeds. 
For .xlsx the problem does not occur.

In attachment:
lo_master.xls - the spreadsheet with external link created in LO.
mso_master.xls - the spreadsheet with external link created in MSO.
down/slave.xls - the spreadsheet for external link.
lo_master.xlsx - the .xlsx spreadsheet with external link created in LO.
Comment 1 raal 2015-03-28 19:15:57 UTC
Hello geeker,
thanks for reporting bug.
Please try following:

- In down/slave.xls rename name of the sheet "Лист1" - new name for example "list1". No cyrillic characters.
- in lo_master.xls delete all formulas and create new link to slave.xls.

Let me know if it works for you and set to bug to unconfirmed.
Thank you

(ref.85617)
Comment 2 m.a.riosv 2015-03-28 21:54:51 UTC
There is an option for save with relative/absolute paths.

Menu/Tools/Options/Load-Save/General - Save URLs relative to file system.

Is the option marked?
Comment 3 geeker 2015-03-29 19:55:52 UTC
(In reply to m.a.riosv from comment #2)
> There is an option for save with relative/absolute paths.
> 
> Menu/Tools/Options/Load-Save/General - Save URLs relative to file system.
> 
> Is the option marked?

Yes, it's marked.
Comment 4 geeker 2015-03-29 20:16:04 UTC
(In reply to raal from comment #1)
> Please try following:
> 
> - In down/slave.xls rename name of the sheet "Лист1" - new name for example
> "list1". No cyrillic characters.
> - in lo_master.xls delete all formulas and create new link to slave.xls.
> 
> Let me know if it works for you and set to bug to unconfirmed.
> Thank you
> 
> (ref.85617)

No, it don't work
Comment 5 raal 2015-03-30 08:02:57 UTC
Tested now with  4.4.1.2 ID build: 45e2de17089c24a1fa810c8f975a7171ba4cd432, win7 and can not confirm. I created new files. Please test with 4.4.1.2, https://www.libreoffice.org/download/libreoffice-fresh/
Comment 6 geeker 2015-03-30 16:48:29 UTC
Created attachment 114468 [details]
test with 4.4.1.2
Comment 7 geeker 2015-03-30 16:54:26 UTC
(In reply to raal from comment #5)
> Tested now with  4.4.1.2 ID build: 45e2de17089c24a1fa810c8f975a7171ba4cd432,
> win7 and can not confirm. I created new files. Please test with 4.4.1.2,
> https://www.libreoffice.org/download/libreoffice-fresh/

I tested with 4.4.1.2 yesterday. And repeated now (see "test with 4.4.1.2" attachment).
Can you load your new file?
Comment 8 raal 2015-03-30 17:29:48 UTC
I can reproduce with Version: 4.4.3.0.0+
Build ID: 3eba5eb1774ab621a1f0f4dcc7e82cce6c025b0a
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2015-03-27_09:07:12

reproducible with LO 3.5
Comment 9 geeker 2015-08-26 15:58:16 UTC
It's reproduced in Version 5.0.0.5.
Comment 10 Cor Nouws 2015-12-02 16:40:15 UTC
version 3.5 per comment 8. 
Possibly inherited from OOo ?
Comment 11 Gunnar Eikman 2016-03-06 21:14:36 UTC
I have a set of Calc  (.ods) spreadsheets which I share between a Linux and a Windows computer. There are references between the files, which used to work fine.

I upgraded the Linux from Ubuntu from 12.04 to 14.04 and now references across files don't work when I open the files on the Windows computer. The references appear to be "absolute", when using Windows. I see the Linux paths/filenames in cell formulas. 

However, if I copy the files to a different directory on the Linux machine, Libre Office 4.2.8.2 happily opens them, dealing with the references.

On Linux I use Libre Office 4.2.8.2. On the Windows machine I have Open Office 3.4.1.

My conclusion: LO 4.2.8.2 and OO 3.4.1 both deal correctly with relative file references, but somehow they don't agree on the file format (like LO 3.5 (?) and OO 3.4.1 used to.
Comment 12 Gunnar Eikman 2016-03-06 21:27:59 UTC
If I open the files (unzipping and inspection the content.xml) it turns out that both newly modified files and older ones actually contain "absolute paths".

Somehow these must be dealt with when the file is opened, but I can't figure out how.

I guess I am suggesting that there has been a change (although I can't figure it out) as to how file paths/names are managed in new LO versions. Possibly the same change fools not only OO 3.4.1 but also Excel...

Sounds vague, I guess...
Comment 13 Cor Nouws 2016-03-07 10:11:50 UTC
(to be honest, I get the feeling too that links tend to work not always reliable, in the various scenario's.. Have seen, tested and commented quite some issues about it.)
Comment 14 geeker 2016-03-10 17:42:34 UTC
Win7x64 Version: 5.1.1.3 (x64) Build ID: 89f508ef3ecebd2cfb8e1def0f0ba9a803b88a6d
Unfortunately, work with external links was broken also in xlsx.
Comment 15 QA Administrators 2017-11-30 06:27:31 UTC Comment hidden (spam)