Issue 95154 - Lock-file on DDE sources gets not removed
Summary: Lock-file on DDE sources gets not removed
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-19 14:33 UTC by andreschnabel
Modified: 2014-07-13 10:37 UTC (History)
6 users (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 09:25 UTC, bmarcelly
no flags Details
Destination spreadsheet, adapt the DDE file address (9.29 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-03-10 09:27 UTC, bmarcelly
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description andreschnabel 2008-10-19 14:33:04 UTC
If a calc file is used as source of a DDE-Link, it gets locked (a lockfile is
created) if the destination of the link refreshes the data. 
But the lock is never removed (not after the refresh has been done, not after
the destination has been closed, not after closing OOo). Only way to correctly
remove the lock is to open and close the file that is used as source for the
DDE-Link.
Comment 1 bmarcelly 2008-12-19 10:40:56 UTC
I confirm this bug on DEV300m37 /Windows XP :
Open the destination first,
Answer Yes to request for links update, 
Open the source Calc : read-only

But no such problem on OOo 3.0 300m9 /Windows XP, so for me it is a regression.
Also, not such problem on 1.1.5.

On DEV300m37 this still works OK:
First open the source Calc
Then open the destination Calc, answer Yes to request for updating links
The source can still be modified and it is reflected in the destination.
Comment 2 stefan.baltzer 2009-03-06 17:03:16 UTC
Put MAV and myself on c/c.
Comment 3 mikhail.voytenko 2009-03-09 18:49:30 UTC
This looks pretty like a duplicate to issue 79632.

Anyway, the lock files should not be created any more since the links are now
opened readonly for update. This is done starting from DEV300_m36.

mav->bmarcelly: Sorry, I can not completely understand your comment. Does it
work in DEV300m37 or doesn't it? Anyway, the document is readonly because the
link window is opened, I suspect. Please try to switch the document in edit
mode, if I am right with my understanding, it should work. It is a different
problem, although it also will be fixed when issue 79632 is fixed.
Comment 4 bmarcelly 2009-03-10 09:24:41 UTC
-> mav : I don't have DEV300m37 anymore, but I have DEV310m2. I will detail the 
problem.

These tests were done with DEV310m2 without the Quick Starter, on Windows XP, from 
the same user.
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 each test, respect the order of actions.

*** test 1A ***
Open DDE_Test; answer yes to link update
Open LinkSource -> bug : it appears as read-only
Switch LinkSource in edit mode, leaving DDE_Test open.
Change a cell in LinkSource : it is reflected in DDE_Test. This is OK.

close all files and OOo.

*** test 1B ***
Open DDE_Test; answer yes to link update
Open LinkSource -> bug : 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

close all files and OOo.

*** test 2 ***
Open DDE_Test; answer yes to link update
Close DDE_Test but not OOo, the Welcome screen appears.
Open LinkSource : 
 -> bug : it appears as read-only (remember : DDE-Test is closed)
 -> bug : LinkSource appeared in another window, the Welcome screen window is still 
visible
Close LinkSource but not its window : you have now 2 Welcome screens !
Reopen Source : now it is writeable. You still have a welcome window.

close OOo.

*** test 3 *** correct result
Open LinkSource
Open DDE_Test; answer yes to link update
Modify a cell in LinkSource : it is reflected in DDE_Test. This is OK.

_____

Issue 79632 is currently targetted at OOo 3.2. I would rather see these bugs 
qualified as 3.1 stoppers.
Comment 5 bmarcelly 2009-03-10 09:25:43 UTC
Created attachment 60844 [details]
Source spreadsheet for DDE links
Comment 6 bmarcelly 2009-03-10 09:27:22 UTC
Created attachment 60845 [details]
Destination spreadsheet, adapt the DDE file address
Comment 7 mikhail.voytenko 2009-03-10 09:46:55 UTC
mav->bmarcelly: Thank you for the detailed description of the bugs, you have
found. But this bug is about remaining lock files. Your scenarios describe other
problems.
Please open standalone issues for the mentioned scenarios, and send them to me:
 - one for a document opened readonly ( first problem in 1A and 1B )
 - one for last bug in "test 1B" ( it looks more like an enhancement request,
but we can discuss it in the new bug )
 - one for the last bug in "test 2"

The issue 79632 was always there, it has just affected the functionality in
different ways. The current situation ( the linked document is opened readonly )
is the least problematic from possible, there is an easy workaround to let the
document be editable. Since the issue 79632 is old, and the problem caused by it
in the current version has an easy workaround, I would not declare it as a
showstopper.

By the way, I would close this issue, since the lock files should not remain any
more.
Comment 8 Serkan 2014-07-13 10:37:26 UTC
I'm still having the same (sort of) problem in OO 4.0.1. 

In my case I have a csv file as a source which I access via DDE and this csv file gets locked as long as OO is open. When I close OO the lock is gone, but what I want to see is realtime update of my spreadsheet, but this is not possible.

And  i've also noticed that the DDE formule gets saved in the cells as long as you are working with an odx file. If you use xls format, save your DDE formula (=link to another source file), close the app and reopen the file, you will see =NA() in all cells.

Really annoying !