Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Lock-file on DDE sources gets not removed | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | andreschnabel <andre.schnabel> | ||||||
Component: | open-import | Assignee: | AOO issues mailing list <issues> | ||||||
Status: | CONFIRMED --- | QA Contact: | |||||||
Severity: | Trivial | ||||||||
Priority: | P3 | CC: | issues, kamataki, marcelly.bernard, mikhail.voytenko, S.Eskici, stefan.baltzer | ||||||
Version: | OOo 3.0 | ||||||||
Target Milestone: | --- | ||||||||
Hardware: | All | ||||||||
OS: | All | ||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
Description
andreschnabel
2008-10-19 14:33:04 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. Put MAV and myself on c/c. 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. -> 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. Created attachment 60844 [details]
Source spreadsheet for DDE links
Created attachment 60845 [details]
Destination spreadsheet, adapt the DDE file address
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. 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 ! |