DOES DDE FUNCTION SUPPORT EXCEL XLSX FORMAT FILES

Trying to verify that the dde function in version 7.0 in windows 10 will work with xlsx files converted from excel under windows 8 to LibreOffice Calxc workbooks under windows 10

an known issues?
thanks

Hello,

assuming you mean this

https://wiki.documentfoundation.org/Documentation/Calc_Functions/DDE

You might like to have a look at the open issues in the bugtracker regarding DDE

https://bugs.documentfoundation.org/buglist.cgi?quicksearch=dde

All known issues, should be listed there.

Hope that helps.


To show the community your question has been answered, click the ✓ next to the correct answer, and “upvote” by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!


Have a nice day and let’s (continue to) “Be excellent to each other!”


Ask / Getting Started:

https://wiki.documentfoundation.org/Ask/Getting_Started

open issues in the bugtracker regarding DDE

Very unfortunate search expression as it lists all issues that contain the three letters dde somwhere like in added …

You are right, what would be a better one?

https://bugs.documentfoundation.org/buglist.cgi?component=Calc&product=LibreOffice&query_format=advanced&resolution=---&short_desc=DDE&short_desc_type=anywords

Yes, it works, use for example

=DDE("soffice";"C:\path\filename.xlsx";"Sheet1.A1")

or if a file was already converted to ODF .ods (there’s no Calcx) then use

=DDE("soffice";"C:\path\filename.ods";"Sheet1.A1")

And please don’t scream by typing all uppercase…