Bug 98085 - FILESAVE/OPEN as .xlsx destroys link to other document
Summary: FILESAVE/OPEN as .xlsx destroys link to other document
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, filter:xlsx, regression
Depends on:
Blocks:
 
Reported: 2016-02-22 18:07 UTC by Stéphane Aulery
Modified: 2017-12-30 11:30 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
Second target file (4.45 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-02-22 18:08 UTC, Stéphane Aulery
Details
First target file (4.45 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-02-22 18:08 UTC, Stéphane Aulery
Details
First file with a link (4.94 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-02-22 18:09 UTC, Stéphane Aulery
Details
Second file with a link (4.96 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-02-22 18:09 UTC, Stéphane Aulery
Details
Howto reproduce this bug 1 (145.11 KB, image/png)
2016-02-22 18:10 UTC, Stéphane Aulery
Details
Howto reproduce this bug 2 (249.87 KB, image/png)
2016-02-22 18:10 UTC, Stéphane Aulery
Details
Howto reproduce this bug 3 (148.03 KB, image/png)
2016-02-22 18:10 UTC, Stéphane Aulery
Details
Howto reproduce this bug 4 (162.44 KB, image/png)
2016-02-22 18:10 UTC, Stéphane Aulery
Details
Howto reproduce this bug 5 (152.08 KB, image/png)
2016-02-22 18:11 UTC, Stéphane Aulery
Details
Howto reproduce this bug 6 (153.04 KB, image/png)
2016-02-22 18:11 UTC, Stéphane Aulery
Details
Paths options (47.15 KB, image/png)
2016-02-23 09:54 UTC, Stéphane Aulery
Details
Load / Save settings (52.93 KB, image/png)
2016-02-23 09:55 UTC, Stéphane Aulery
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Stéphane Aulery 2016-02-22 18:07:48 UTC
Hello,

I made two XLSX documents with LO, and linked the second (bbb.xlsx) to the first (bbb.xslx).

When I insert the link, it is ok. If I save, close and reopen the document which contains this link, it is broken. The tooltip display that the path has been corrupted.

It keep file name but drop directories path :

    file:///C:\Users\saulery\Downloads\aaa.xlsx

become

    file:///aaa.xslx

But with this other path it's right :

file:///C:\Users\Stephanus\myfile.xslx

(linked in myfile2.xslx)

Tested on Windows 7 32bit with LO 5.0.1.2

Regards,

-- 
Stéphane Aulery
Comment 1 Stéphane Aulery 2016-02-22 18:08:23 UTC
Created attachment 122874 [details]
Second target file
Comment 2 Stéphane Aulery 2016-02-22 18:08:42 UTC
Created attachment 122875 [details]
First target file
Comment 3 Stéphane Aulery 2016-02-22 18:09:09 UTC
Created attachment 122876 [details]
First file with a link
Comment 4 Stéphane Aulery 2016-02-22 18:09:24 UTC
Created attachment 122877 [details]
Second file with a link
Comment 5 Stéphane Aulery 2016-02-22 18:10:00 UTC
Created attachment 122878 [details]
Howto reproduce this bug 1
Comment 6 Stéphane Aulery 2016-02-22 18:10:21 UTC
Created attachment 122879 [details]
Howto reproduce this bug 2
Comment 7 Stéphane Aulery 2016-02-22 18:10:34 UTC
Created attachment 122880 [details]
Howto reproduce this bug 3
Comment 8 Stéphane Aulery 2016-02-22 18:10:47 UTC
Created attachment 122881 [details]
Howto reproduce this bug 4
Comment 9 Stéphane Aulery 2016-02-22 18:11:00 UTC
Created attachment 122882 [details]
Howto reproduce this bug 5
Comment 10 Stéphane Aulery 2016-02-22 18:11:12 UTC
Created attachment 122883 [details]
Howto reproduce this bug 6
Comment 11 Cor Nouws 2016-02-22 20:07:39 UTC
Hi Stéphane,

Thanks for filing here!

(In reply to Stéphane Aulery from comment #0)

> It keep file name but drop directories path :
>     file:///C:\Users\saulery\Downloads\aaa.xlsx
> become
>     file:///aaa.xslx

I confirm with a recent daily build on Ubuntu that a link,
inserted with Insert > Hyperlink > ... document
 link:file:///home/cono/name.xlsx
changes to 
 link:file:///name.xlsx
after closing and reopening.

 **  Version: 5.2.0.0.alpha0+
Build ID: a3c70e760fa4203b7e6692f82d1d8a14214af3da
CPU Threads: 2; OS Version: Linux 4.2; UI Render: default; 
TinderBox: Linux-rpm_deb-x86@71-TDF, Branch:master, Time: 2016-02-17_23:47:57
Locale: nl-NL (nl_NL.UTF-8)
 ** Setting Tools > OPtions > Load/Save > General > Save URL relative is checked.

> But with this other path it's right :
> 
> file:///C:\Users\Stephanus\myfile.xslx

What is your My Documents setting in Tools > OPtions > LibreOffice > Paths ?

What is your Save URL relative setting in setting in Tools > OPtions > Load/Save > General > .. ?
Comment 12 Stéphane Aulery 2016-02-22 20:18:56 UTC
Hello Cor,

I can’t vien it before tomorrow. In fact, it’s just the defaut values unchanged under windows 32bit version.
Comment 13 Stéphane Aulery 2016-02-23 09:54:32 UTC
Created attachment 122900 [details]
Paths options
Comment 14 Stéphane Aulery 2016-02-23 09:55:02 UTC
Created attachment 122901 [details]
Load / Save settings
Comment 15 Stéphane Aulery 2016-02-23 09:57:37 UTC
Hello Cor,

I have added two screenshots which show my settings.
Did you need something else?

Regards,
Comment 16 Cor Nouws 2016-02-23 10:20:11 UTC
(In reply to Stéphane Aulery from comment #15)

> Did you need something else?

Thanks.
If you save a new document in LibreOffice, at which path is it placed?
Comment 17 Stéphane Aulery 2016-02-23 12:56:46 UTC
Apparently, at the location of the last file saved earlier.
Comment 18 raal 2016-02-24 11:33:30 UTC
Reproducible with Version: 4.5.0.0.alpha0+
work with Version 4.0.0.3
Comment 19 raal 2016-02-29 19:49:07 UTC
reproducible with Version: 4.2.0.0.alpha1+
Comment 20 Xisco Faulí 2016-09-12 12:21:24 UTC
Adding keyword 'bibisectRequest'.
Comment 21 raal 2016-10-13 21:44:06 UTC
This seems to have begun at the below commit.
Adding Cc: to Noel Power ; Could you possibly take a look at this one?
Thanks
 da2a0752e1bb84d2a4922ea54c5d95c592d93871 is the first bad commit
commit da2a0752e1bb84d2a4922ea54c5d95c592d93871
Author: Matthew Francis <mjay.francis@gmail.com>
Date:   Sat Sep 5 19:24:35 2015 +0800

    source-hash-40dd3d6e4ed8ed6a2f1c3f953955f9932c0c95ce
    
    commit 40dd3d6e4ed8ed6a2f1c3f953955f9932c0c95ce
    Author:     Noel Power <noel.power@suse.com>
    AuthorDate: Wed Jul 24 12:36:54 2013 +0100
    Commit:     Noel Power <noel.power@suse.com>
    CommitDate: Wed Jul 24 12:41:45 2013 +0100
    
        followup fix for bnc#823935 exported xlsx causes errors for mso2007
    
        previously we added 'file://' scheme to hyperlink urls detected as SMB
        but.. this is just how linux detects those windows share urls, on
        windows those urls are detected simply as FILE urls. So... we need
        to add the scheme if either FILE or SMB ( basically just relax the patch
        a little )
    
        Change-Id: Ie9a2b0c9e297ee08352db88ad9a21583978dbe3d
Comment 22 Cor Nouws 2016-10-14 13:17:06 UTC
I'm afraid Noel is not going to put effort in this .. ?
Comment 23 QA Administrators 2017-10-23 14:13:41 UTC Comment hidden (obsolete)
Comment 24 Cor Nouws 2017-12-30 11:30:05 UTC
works OK in Version: 6.1.0.0.alpha0+
Build ID: a9b202a6b7000e7af34f2a639ca207122a3968bf
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-12-26_23:09:36
Locale: nl-NL (nl_NL.UTF-8); Calc: group threaded