DDE() taking minutes while the CPU has a party

users
#1

Hey guys,

I have a document with about 20 columns and 500 rows using
DDE("soffice", …) to get the data from another doucment. The reason
I am using DDE() instead of an array reference to the other file is
that the array reference does not grow, i.e. if the referred file
has a line added, I have to erase and recreate the array, whereas
I can just add additional DDE() lines.

The problem I am having is that with 500 lines, adding a new line
(using fill-down) takes about *an hour per line*, so to add 6 lines,
I just had the machine chugging at 100% CPU time for 6 hours, while
libreoffice was entirely unresponsive.

Do you have any idea what's going on, or how to optimise this?

Thanks,