Bug 106074 - 'Link to External Data...' data duplicated in new cells on opening file and updating link
Summary: 'Link to External Data...' data duplicated in new cells on opening file and u...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.0.3 release
Hardware: All All
: high normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks: Calc-External-Datalink
  Show dependency treegraph
 
Reported: 2017-02-18 09:53 UTC by email
Modified: 2017-08-28 19:15 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Test file (data duplicated in new cells on opening file and updating external link) (8.69 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-02-18 09:53 UTC, email
Details
Modified test file. (10.26 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-02-18 18:17 UTC, m.a.riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description email 2017-02-18 09:53:45 UTC
Created attachment 131312 [details]
Test file (data duplicated in new cells on opening file and updating external link)

Bug:
Using data from an external link, when the spreadsheet is opened and the link is updated, some data from the link (but not all) is duplicated and displayed below the existing data.

Expected behavior:
Existing data should be updated/overwritten (rather than duplicated in new cells below existing data).

Steps to reproduce problem:
(1) Open new spreadsheet
(2) 'Sheet -> Link to External Data...'
(3) Use "http://google.com/finance" and select HTML_3 (data is inserted as expected... OK so far)
(4) Save and close spreadsheet
(5) Open spreadsheet and allow link to be updated - some of the data is duplicated below the original data

Attachment:
The attached file has "http://google.com/finance" HTML_3 inserted into H5 (an arbitrary cell for an example). There is no other content in the spreadsheet.
When you open the file, as soon as you click "Yes" to "This file contains links to other files. Should they be updated?", you should see 3 additional lines of text (the last 3 lines of the external data) being added below the existing data. Each time you save and open the file, 3 more lines will be added.

Note:
The amount of data duplicated when the link is updated seems to be related to the cell that the link is inserted into.
For the example attached, 3 lines of data are duplicated (each time the file is opened and the link is updated) when "http://google.com/finance" HTML_3 is inserted into H5.
In N6 (for example), 6 lines of data are duplicated each time.
However, when the link is inserted into A1, no data is duplicated.
Comment 1 m.a.riosv 2017-02-18 18:17:38 UTC
Created attachment 131324 [details]
Modified test file.

Maybe something is wrong with your link, creating a new one, with the same address doesn't seem to reproduce the issue.
Comment 2 email 2017-02-18 21:20:38 UTC
D5 (where you've inserted the link in your sample file) seems to be a cell where the problem does not happen. Try H5, J1 or N6 (just arbitrary cells where the problem can be reproduced consistently).

I've been using the same link in various versions of LibreOffice over the years (in the same spreadsheet with the link in the same cell) and the problem started only when I installed 5.3.0.3.

Does not happen in 5.2.5.1.
Comment 3 Joel Madero 2017-02-19 04:44:22 UTC
Confirmed but some interesting findings:

With your attachment I can confirm with:
Version: 5.2.5.1
Build ID: 1:5.2.5~rc1-0ubuntu1~xenial0
CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; VCL: gtk2; 
Locale: en-US (en_US.UTF-8); Calc: group

and 

Version: 5.4.0.0.alpha0+
Build ID: 12899c07be2f927776ae12ea1abcefdc4bea8346
CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; VCL: gtk2; 
Locale: en-US (en_US.UTF-8); Calc: group

but with a new file and creating from scratch, I can confirm the regression