| Summary: | DDE does not trigger XModifyListener | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Andreas Säger <villeroy> |
| Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | CC: | sasha.libreoffice |
| Version: | 3.3.4 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| i915 platform: | i915 features: | ||
| Attachments: | Calc/Basic demo to test DDE "stealth mode" | ||
Same problem in: OOo 2.4.3 OOo 3.3 LibO 3.3.4 LibO 3.4.3 in 3.3.4 when I paste cell and select "Link" it pastes as this:
=DDE("soffice";"/home/s/Untitled 2.ods";"Sheet1.A1")
But in 3.5.2 as this:
='file:///home/s/Untitled 2.ods'#$Sheet1.A1
Script produces new line:
3.3.4 : after press F9
3.5.2 : after press Ctrl-Shift-F9
on Fedora 64 bit in 3.3.4 dde link not updates automatically, in 3.5.2 not creates automatically. But if create dde link in 3.3.4 and then open spreadsheet in 3.5.2 then it updates automatically. on Windows XP: in 3.4.3 opens correctly file with dde link, created on Linux (content of cell was this: ='file:///home/s/Untitled 2.ods'#$Sheet1.A1 ) 3.5.2 can not open this file correctly, because can not find file Untitled 2.ods (it is in the same folder) So we see some regression or new feature in working with dde or link. What about original problem, it reproducible in 3.3.4 and 3.5.2 on Fedora 64 bit and in 3.4.3 on Windows XP 32 bit changing version to 3.3.4 as most early reproducible of original problem after 3.5.0 appears regression with creating/updating of dde Please separate these bugs. Otherwise this bug report is totally useles and can be closed immediately. sasha.libreoffice@gmail.com, Your problem is totally unrelated to my one. You should not post any bug report unless you are sure that you found a bug. Instead you should post to some support forum or mailing list. I just tested on my system: ='file:///tmp/s/Untitled 1.ods'#$Sheet1.A1 =DDE("soffice";"/tmp/s/Untitled 1.ods";"Sheet1.A1") They do not do exactly the same, but both methods work as advertised for me. Both return the value of cell A1 on Sheet1 in the referenced file. The URL method wods like a relative link with relative reference whereas the DDE method with its constant strings behaves like an absolute link with an absolute reference. When I move the s folder to my home directory, the URL will adjust to the new location whereas the DDE formula keeps its constant strings. When I copy the relative URL-reference, the copied cells behave just like relative references. The method which is used for the "Link" option in paste-special seems to have changed which does not mean that it is a bug. You can still use DDE. Sorry for my comments. Please, ignore all my comments in this bugreport ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (4.3.5 or later): https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) Thank you for your help! -- The LibreOffice QA Team |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 52654 [details] Calc/Basic demo to test DDE "stealth mode" Trying to code a simple DDE logger in Calc/Basic, I notice that my c.s.s.util.XModifyListener is triggered by all kinds of changes and hard recalculation but not when a new DDE value arrives.