Bug 55009 - : Cell content based on linked document does not load
Summary: : Cell content based on linked document does not load
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2012-09-17 11:25 UTC by Callegar
Modified: 2014-01-17 09:32 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Callegar 2012-09-17 11:25:36 UTC
Problem description: 

Say you have 2 spreadsheets A and B. B names some cell set in A say 'dataset'. Furthermore, B has some cells whose content is a formula whose value depends on a search done in 'dataset'.

If you open A and then you open B, on opening B, libreoffice says that B has cells with content linking stuff in another file and asks if you want to update it. If you say 'yes', then B becomes visible with all the updated content from A in its cells.

Conversely, if you open B, but you have not opened A before B, libreoffice still recognizes the presence of linked content. Furthermore it still asks if you want to update the cells based on the linked content. However, after you answer yes or no, B becomes visible with all the cells based on the content of A in an error state.

Apache Openoffice 3.4.1 has the same problem. However, I am almost sure that ancient versions of Sun openoffice used to do it right.

Platform (if different from the browser): 
Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:15.0) Gecko/20100101 Firefox/15.0.1
Comment 1 Joel Madero 2013-05-30 17:48:29 UTC
Almost definitely a duplicate of 57738 - marking as such

*** This bug has been marked as a duplicate of bug 57738 ***
Comment 2 Markus Mohrhard 2013-06-07 03:42:19 UTC
Not a duplicate.
Comment 3 Joel Madero 2014-01-17 03:24:36 UTC
So if I understand this right:

Setup file a.ods and put the value "the" in A1 without quotes
Setup file b.ods, set A1 =FILEPATH/a.ods'#$Sheet1.A1

Save both.

Open a.ods, open b.ods, click "yes" for update link

See: works

Close both, open b.ods, select yes for update links

You observed an error, I do not.

Assuming these steps are correct, marking as WFM as it seems like it is now resolved.

Tested on:
Ubuntu 13.10
LibreOffice RC

If this is still an issue for you with 4.2 when it is released, please set it back to UNCONFIRMED and detail the exact steps that you used. Thanks!
Comment 4 Callegar 2014-01-17 09:32:27 UTC
Yes, I agree... I have checked again and it seems OK to me too in recent LibO.