[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell
https://bugs.documentfoundation.org/show_bug.cgi?id=127210 --- Comment #13 from QA Administrators --- Dear Bernard, 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 with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. 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) from https://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: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell
https://bugs.documentfoundation.org/show_bug.cgi?id=127210 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC||79045_79...@mail.ru Blocks||108827 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell
https://bugs.documentfoundation.org/show_bug.cgi?id=127210
--- Comment #12 from Oliver Brinzing ---
Created attachment 155153
--> https://bugs.documentfoundation.org/attachment.cgi?id=155153=edit
screenshot
after i managed to run the server and demo java client, i started a test with a
spreadsheet using LO 6.1:
- new spreadsheet
- cell B1: =DDE("MyServer";"MyTopic"; "MyRequest") -> #NV
- cell B2; =DDE("MyServer";"MyTopic"; "MyAdvise") -> #NV
- save spreadsheet
- reload spreadsheet and enable link update
-> B1 shows a result, e.g. "MyRequest data 53"
-> B2 shows "MyAdvise data 54" and counts the values *permanently* high
- save & close spreadsheet
- load spreadsheet and enable link update again
-> B1 sometimes shows a result, e.g. "MyRequest data 53"
but sometimes result is empty.
-> B2 shows "MyAdvise data 54" and counts the values *permanently* high
noticed:
the problem ssems not to happen if i use only formula in cell B1
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell
https://bugs.documentfoundation.org/show_bug.cgi?id=127210 Bernard changed: What|Removed |Added Attachment #153731|0 |1 is obsolete|| --- Comment #11 from Bernard --- Created attachment 155144 --> https://bugs.documentfoundation.org/attachment.cgi?id=155144=edit Test cases in zip file New test cases matching DDE MyServer. There is an interesting additional bug with the formula getting the "Mode" parameter from another cell: If we copy the formula into the cell directly, then it works (before saving). However if we use the cell editing functionality [Ctrl+V] after [F2], then the entered formula breaks immediately. Just another bug that might show the way to a solution. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell
https://bugs.documentfoundation.org/show_bug.cgi?id=127210
--- Comment #10 from Bernard ---
The bug can be reproduced easily with a mature and well-documented DDE server
sample provided at https://sourceforge.net/projects/jdde/ with instructions how
to run it at
http://jdde.pretty-tools.com/en/examples/ddeserverexample.htm
Prerequisite is a Java JRE (Java Runtime Environment) installed and available
on the path in a command window.
To run the DDE server, from command line, we execute:
java -cp pretty-tools-JDDE-2.1.0.jar;pretty-tools-JDDE-2.1.0-examples.zip
DDEServerExample
This runs the DDE server. This can be tested with the provided DDE clients:
http://jdde.pretty-tools.com/en/examples/requestexample.htm
java -cp pretty-tools-JDDE-2.1.0.jar;pretty-tools-JDDE-2.1.0-examples.zip
RequestExample
and
http://jdde.pretty-tools.com/en/examples/adviceexample.htm
java -cp pretty-tools-JDDE-2.1.0.jar;pretty-tools-JDDE-2.1.0-examples.zip
AdviceExample
Then in a new spreadsheet, we enter into two cells:
=DDE("MyServer", "MyTopic", "MyRequest")
=DDE("MyServer", "MyTopic", "MyAdvise")
1) Both cases do NOT work with a new unsaved sheet, but they DO work with a
sheet where these formulas have been saved before.
2) If then you enhance the DDE formulas to get the "Mode" parameter values
"MyRequest" and "MyAdvise" from other cells A1 and A2, then this reproduces the
issue in such a way that after saving and retrieving the document, the new
formula cells contain the text "=NA()", meaning that the formula is lost. While
any simple formulas in the same sheet still work.
Cell entries, cell borders indicated by "|", line number shown first:
|A|B|
1|MyRequest|=DDE("MyServer", "MyTopic", A1)|
2|MyAdvise|=DDE("MyServer", "MyTopic", A2)|
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell
https://bugs.documentfoundation.org/show_bug.cgi?id=127210 Bernard changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #9 from Bernard --- I think that the status can be changed to NEW because TD Ameritrade support engineers could reproduce / confirm on multiple computers the case where a DDE link breaks in a new spreadsheet while this works in MS Excel spreadsheets. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell
https://bugs.documentfoundation.org/show_bug.cgi?id=127210 --- Comment #8 from Bernard --- Thanks for looking into this. The different situation just illustrates the point that there IS a problem with DDE and LibreOffice that I should not be able to produce at my computer no matter how hard I try. This situation does not have a separate test case at this point, so please don't wait for one. Your case where it works with the soffice DDE server would not mean much as in my attached test cases, even the complex case works with the soffice DDE server at my end, where the other problems persist. What the original issue would require is the attention of a DDE / Libre Office expert. To the extent that we get the chance to experiment with test DDE clients and servers with logging capabilities. At this stage, no serious questions have been asked with respect to the resolution of the problem. I would imagine that DDE is perhaps one of the more complex parts of the system. It is quite possible that the TOS DDE server I use may play an important role in this, and we would need the ability to potentially pinpoint a problem to the extent that we can engage the vendor of that DDE server, in case that this server causes the problem. But to do that, we would first need to analyze. So to get this issue into a confirmed state needs some expert analysis. I am more than happy to help there if required because I have computer programming skills (Java), but not Windows native and DDE. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell
https://bugs.documentfoundation.org/show_bug.cgi?id=127210
--- Comment #7 from Oliver Brinzing ---
(In reply to Bernard from comment #6)
> The DDE formula breaks in the new sheet. This does not make sense to me. It
> is as simple as it gets.
i tried with a DDE formula like this:
=DDE("soffice";"d:\dde_src.ods";"sheet1.a1")
and it works immediately if i copy the formula cell to a new sheet.
Can you please add a test case for the new scenario?
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell
https://bugs.documentfoundation.org/show_bug.cgi?id=127210 --- Comment #6 from Bernard --- Now I have a different situation, much easier: 1) I open an old spreadsheet with many DDE formulas that do actually work. 2) I click on the dialog "Automatic update of external links has been disabled. [Enable Content] [X]" 2) I copy from one cell in that sheet a working DDE formula to the clipboard. 3) I create a new sheet 4) I paste the formula into that sheet. The DDE formula breaks in the new sheet. This does not make sense to me. It is as simple as it gets. I suspect that the problem may come from the fact that I did not somehow enable "Automatic update of external links" in the new sheet. I don't get that dialog. If I save the sheet and re-open it, then I get the dialog and the formula works. So getting this dialog seems to be essential. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell
https://bugs.documentfoundation.org/show_bug.cgi?id=127210 Bernard changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 --- Comment #5 from Bernard --- It might be of interest that I tried a workaround by generating the DDE function with hard-coded parameters in order to avoid the complexity, using apache POI. That failed as well: Failure to generate DDE formula in HSSFWorkbook https://bz.apache.org/bugzilla/show_bug.cgi?id=63709 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell
https://bugs.documentfoundation.org/show_bug.cgi?id=127210 Bernard changed: What|Removed |Added Attachment #153727|0 |1 is obsolete|| --- Comment #4 from Bernard --- Created attachment 153731 --> https://bugs.documentfoundation.org/attachment.cgi?id=153731=edit Test cases in zip file My apologies. New zip file should replace old. To reproduce this at your end might be difficult, and I might need to supply additional information. First, I am using the Ameritrade Thinkorswim platform as a DDE server "TOS" which is perhaps not available to you. Perhaps you have a different DDE client that might function in a similar manner. Perhaps you want to play around with these files to get an idea. I am truly sorry about this. But on the other hand, it is a trivial case in a way and in another way it is not. I am thinking that you might have the desire to break the DDE function in such a way that this reproduces at your end. That would be ideal. I have been using DDE in Calc with the hard-coded Item/range parameter for years in hundreds of spreadsheets with the same TOS server for years and I did not find a single problem. In fact I switched to Calc from Excel because Excel locked up occasionally! Now I cannot get this slightly more complex version to work at all. I think it makes so much more sense to fetch the Item/range parameter from a separate cell where it is visible. Many thanks in advance. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell
https://bugs.documentfoundation.org/show_bug.cgi?id=127210 Oliver Brinzing changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 CC||oliver.brinz...@gmx.de --- Comment #3 from Oliver Brinzing --- (In reply to Bernard from comment #0) > Description: > Please use the attached test case spreadsheet file BadComplexTOS.xls Thank you for reporting the bug. Attached "testcase.zip" does not contain a file "BadComplexTOS.xls". And please add a detailed description how the bug can be reproduced with this file. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell
https://bugs.documentfoundation.org/show_bug.cgi?id=127210 --- Comment #2 from Bernard --- Build is actually: Version: 6.2.5.2 (x64) Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159 CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win; Locale: en-NZ (en_NZ); UI-Language: en-US Calc: CL -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell
https://bugs.documentfoundation.org/show_bug.cgi?id=127210 --- Comment #1 from Bernard --- Created attachment 153727 --> https://bugs.documentfoundation.org/attachment.cgi?id=153727=edit Test cases in zip file -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
