https://bugs.documentfoundation.org/show_bug.cgi?id=127210
--- Comment #10 from Bernard <[email protected]> ---
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
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
