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.
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
Paste-special some other saved document's cell in B1 with “Link” option in order to create a DDE link. - Value updated OK. Modify the cell value in the other document. - Done. After a short time this sheet's B1 adjusts to the new value without triggering the XmodifyListener. - Did not update by itself. Win 7 Pro 64-bit Version: 4.5.0.0.alpha0+ Build ID: 784d069cc1d9f1d6e6a4e543a278376ab483d1eb TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-01-25_23:07:36
** 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 (5.0.5 or 5.1.0) 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) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-02-21
Works with 4.4.7 and 5.1.
thanks for testing and reporting! When we have no specific commit, we set to WorksForMe.