Apache OpenOffice (AOO) Bugzilla – Issue 82226
Links should be deleted completely if they are not used any longer in document contents
Last modified: 2007-10-15 14:19:41 UTC
This file does not contain links; however, every time it is opened, the dialog asking if the links should be updated is displayed. When the answer given to this dialog is yes, Calc will modify cell G14 with the label "The link could not be updated." Steps to reproduce the error: 1) Open the template or create a new document based on it (either way the results are the same) 2) When prompted to update links to other files, select "Yes" (if you select "no", the cell is not updated) 3) Check the contents of the cell C14 I unzipped the file and searched content.xml for the string "file" but I could not find any match. This is because the file originally contained links to other files using with the "file://" syntax (I do not know if there is another syntax possible). So my guess is that Calc is reading some content and mistaking it as a link. This could be a bug. In any case, cell G14 is being written with an undesired value. This is a bug from my point of view. Hope this helps improving the product. I have only used this file under Windows, so I do not know if the bug persists in another environments. I do know that this file has presented the same behaviour since version 2.0 (or maybe ever since pre-2.0 versions), unfortunately I do not keep a record of this.
Created attachment 48678 [details] Calc template with bug
By the way, I did not want to select the "printing" subcomponent. Anyway, I do not know for sure to which subcomponent this bug is related.
The document does contain a link, as you can siee in the 'edit -> links' dialogue. Although it might not be used in the document, it still is listed somewhere in the XML code and so OOo wants that link to be updated. You get this problem if you create a link to an other spreadsheet like <='file:///C:/Dokumente_und_Einstellungen/Rainer/Eigene_Dateien/TEMP/oootestfiles/82226_links/testfile.ods'#$template.C9> (create it with "=" -> click on cell in other document -> <enter>) and delete the cell contents with the link afterwards. The link to the other document will remain (and is visible in the dialogue box), although it is not really used in the document. I can not see any sense in that behaviour, but currently I am not sure whether this is a bug or a feature. This problem also existed in older OOo versions. I checked with "2.2.1 Multilingual German version WIN XP: [680m18(Build9161)]"
rainerbielefeld: I appreciate your prompt feedback. I certainly did not know about the Edit/Link option. So understanding how this work, I still think that the cell being updated is certainly something neither expected nor desirable from the user point of view. I was able to solve the issue by removing the link using Edit/Link. However, keep in mind that when this document was using the link(s), this behaviour was a problem because the cell lost its contents each time the document was opened, so the user had to manually set the contents again. JC
Hi, this is a double to Issue 15667 . Frank *** This issue has been marked as a duplicate of 15667 ***
closed double