Issue 100086 - DDE link disconnected if source is opened-closed-opened
Summary: DDE link disconnected if source is opened-closed-opened
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO310m2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-03-10 10:36 UTC by bmarcelly
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Source spreadsheet for DDE links (17.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-03-10 10:37 UTC, bmarcelly
no flags Details
Destination spreadsheet, adapt the DDE file address (9.29 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-03-10 10:37 UTC, bmarcelly
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description bmarcelly 2009-03-10 10:36:21 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.
Comment 1 bmarcelly 2009-03-10 10:37:14 UTC
Created attachment 60852 [details]
Source spreadsheet for DDE links
Comment 2 bmarcelly 2009-03-10 10:37:48 UTC
Created attachment 60853 [details]
Destination spreadsheet, adapt the DDE file address
Comment 3 mikhail.voytenko 2009-03-10 10:48:39 UTC
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
Comment 4 bmarcelly 2009-03-10 11:30:05 UTC
-> 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.
Comment 5 mikhail.voytenko 2009-03-10 12:28:12 UTC
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.
Comment 6 Marcus 2017-05-20 11:11:45 UTC
Reset assigne to the default "issues@openoffice.apache.org".