Bug 126698 - Unable to update links to external files in Calc
Summary: Unable to update links to external files in Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.0.0.alpha1+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks: Calc-External-Datalink
  Show dependency treegraph
 
Reported: 2019-08-04 15:18 UTC by Usama
Modified: 2019-08-25 16:18 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
example linked file (7.71 KB, application/zip)
2019-08-04 15:21 UTC, Usama
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Usama 2019-08-04 15:18:47 UTC
Description:
I insert A sheet from file and check the "link" check box. Then when I move the file to another computer or another user on the same system things get messy and I lose the ability to update the link to point to the new file location.

Steps to Reproduce:
1.From "Sheet" menu >> insert sheet... >> chose "from file" and browse for CSV file. Check the "link" check box save the file.
2. From "Edit" menu click "Links to external files.." then "Modify" chose another CSV file then press the update button then save and close the file
3. When you open the file again the link will still show the old CSV file

Actual Results:
OLD file is still linked

Expected Results:
The new file should be linked


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.0.0.alpha0+
Build ID: c54597a8905b07807952aebc24237549302fb941
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-07-10_22:22:02
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 Usama 2019-08-04 15:21:22 UTC
Created attachment 153128 [details]
example linked file
Comment 2 Buovjaga 2019-08-04 17:35:24 UTC
Repro.

Arch Linux 64-bit
Version: 6.4.0.0.alpha0+
Build ID: 4bd1b38633d6cb288eb559afc0ac6b961538ae60
CPU threads: 8; OS: Linux 5.2; UI render: default; VCL: gtk3; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 24 July 2019
Comment 3 m.a.riosv 2019-08-04 22:58:15 UTC
I can't repro with a file from scratch
Version: 6.4.0.0.alpha0+ (x64)
Build ID: b9b7df5f558eb79533622df5f3390f79a1e5aa79
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@62-TDF, Branch:master, Time: 2019-07-31_17:15:25
Locale: es-ES (es_ES); UI-Language: en-US Calc: CL

Sample file has a link relative to not the same folder but xlink:href="../../Downloads/test.txt", so if file is saved with the option for a relative path, and you move to a different place without reproduce the folder's structure then the link doesn't work.
Sample file doesn't update for me with 6.2.5.
Comment 4 Usama 2019-08-05 13:35:48 UTC
Maybe the issue is different with Ms Window? I tried the latest version from master and I still can reproduce it with new file.

Version: 6.4.0.0.alpha0+
Build ID: 9ee5ad5a0b84bfa652da34694ba4f75668f06087
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-07-30_13:21:44
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 5 Buovjaga 2019-08-10 16:16:12 UTC
I repro with steps from description even from scratch on Win (build is latest from TB@39)

Version: 6.4.0.0.alpha0+ (x86)
Build ID: c738be4de6886a0c96b7d10df7e78c8b2964c135
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: fi-FI (fi_FI); UI-Language: en-US
Calc: threaded
Comment 6 Buovjaga 2019-08-10 16:32:39 UTC
I tried to bibisect, but bug is not yet in latest of win32-6.3 repo, yet it is already in the oldest of Linux 6.4 repo!?
Comment 7 Xisco Faulí 2019-08-19 15:00:31 UTC
I can reproduce it back to

Version: 5.2.0.0.alpha1+
Build ID: 5b168b3fa568e48e795234dc5fa454bf24c9805e
CPU Threads: 4; OS Version: Linux 4.15; UI Render: default; 
Locale: ca-ES (ca_ES.UTF-8)

I don't see why it's a regression...

Steps I followed:
1. Create folder Downloads and paste the .txt file there
2. Open the .ODS file
3. Update the link
4. Save
5. Reopen

-> it links to the old file.

Am I missing something ?
Comment 8 Buovjaga 2019-08-25 16:18:23 UTC
(In reply to Xisco Faulí from comment #7)
> Am I missing something ?

Try it from scratch, not with the example ODS file