Query on 'paste special' of a DDE link from Calc cells to Writer endnotes.

asked 2020-06-11 15:19:44 +0200

BAT gravatar image

Hi, I am using LO Version: 6.3.6.2 on MacOs 10.13.6 High Sierra

I am working on a large Writer text document with about 300 endnotes (but I tested and found the same issue in one with hardly any text and just one endnote).

I can copy and ‘paste special’ a DDE link from a Calc cell into the body of the Writer text. That works fine. But when I try to do the same thing into a Writer text endnote LO immediately crashes with the message ‘Due to an error LibreOffice crashed. All the files you were working on will now be saved… etc.’

I have searched and been unable to find the answer/s to my questions below; 1 is using ‘paste special’ of a DDE link into an endnote not enabled, or is it a bug? 2 if it is not enabled/allowed, can LO be enhanced to enable it?

Such functionality would be useful (to me, possibly others). Many of the 300 endnotes in my text cross reference to each other. So, for example, Endnote 1 might say ‘see also Endnote 10’. If, through further work on the text, a new endnote is inserted between 1-10 Endnote 1 should now say ‘see also Endnote 11’.

I have created a Calc spreadsheet (‘note manager’) - it facilitates endnote renumbering (say, if a new endnote is inserted) and endnote cross referencing (as endnote numbers change). If I could use ‘paste special’ to insert a DDE link from the spreadsheet into those endnotes in the Writer text that refer out to other endnotes I would not have to continually update the cross references manually. Thanks in advance for any ideas, comments or suggestions.

edit retag flag offensive close merge delete