[Libreoffice-bugs] [Bug 127210] DDE function breaks if Item/range parameter is from another cell

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127210

--- Comment #10 from Bernard <bht237 at gmail.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191019/6185b162/attachment-0001.html>