Apache OpenOffice (AOO) Bugzilla – Issue 100086
DDE link disconnected if source is opened-closed-opened
Last modified: 2017-05-20 11:11:45 UTC
As requested by mav, separate issue created from Issue 95154 desc5 These tests were done with DEV310m2 without the Quick Starter, on Windows XP, from the same user. Consequences could be worse if the source document is shared among several users. I used these files (next attachments): LinkSource.ods : simply a list of strings in column B DDE_Test.ods : references a range of cells with a DDE formula In the test, respect the order of actions. Open DDE_Test; answer yes to link update Open LinkSource -> bug Issue 100085 : it appears as read-only Close LinkSource, leaving DDE_Test open. Re-open LinkSource : now it is writeable! Change a cell in LinkSource -> bug : change not reflected in DDE-Test The DDE link has been released, the user is not aware of this.
Created attachment 60852 [details] Source spreadsheet for DDE links
Created attachment 60853 [details] Destination spreadsheet, adapt the DDE file address
Please try the following test, to be sure that the main functionality works. [...begin of original scenario...] Change a cell in LinkSource -> bug : change not reflected in DDE-Test Store LinkSource Go to Edit/Links menu entry and update the link explicitly
-> mav : testing your suggestion. ... Change a cell in LinkSource -> bug : change not reflected in DDE-Test Store LinkSource Go to Edit/Links menu entry and update the link explicitly Result : the explicit update of the link works, but only on that link. If you have another link to the same spreasheet, it is not updated. Variant : Open LinkSource -> bug Issue 100085 : it appears as read-only Close LinkSource, leaving DDE_Test open. Re-open LinkSource : now it is writeable! Change a cell in LinkSource -> bug : change not reflected in DDE-Test Leave LinkSource open. Go to Edit/Links in DDE_Test and update the link explicitly Result : the explicit update of the link works, but only on that link. Now the link is updated when a change is made to LinkSource cells. So if you have several ranges linked to LinkSource.ods cell ranges, you would have to Edit > Links > Update for each of these links.
mav->bmarcelly: To get the update automatically the links could be changed to update using a timer as a workaround. Anyway it is a bug and has to be fixed. If I remember the implementation correctly the bug should be an old one.
Reset assigne to the default "issues@openoffice.apache.org".