Re: [libreoffice-users] Err:504 with DDE links since LO 4→5 upgrade

2016-04-20 Thread Regina Henschel

Hi Martin,

martin f krafft schrieb:

Hey list,

We're dealing with a complex document containing hundreds of DDE
links. Worse yet, those DDE links are dynamically created, e.g.
using the following formula to reference filename ($B$2), sheet name,
($B$3), column ($B$6), and row (in column $A starting at $A8):

   =DDE("soffice";
 CONCATENATE("file:./";$B$2);
 CONCATENATE("$";$B$3;".$";$B$6;"$";$A8);
 0)


Such DDE works for me on Windows. But I have no part "file:./" but for 
me it is "c:\". I know Linux has a different way to write a path, but 
are you sure about the part "file:"?


Does DDE works, if you make a new pair of documents (source and target) 
in LibreOffice 5?




This worked very well a year ago, but when we tried to open it as of
late, we get "Err:504" (parameter list error) all over.


You should generate a test file in LibreOffice 4 with a DDE-link, which 
works. (A administrative installation or a portable version should work 
for that.) Then go to Edit > Links.. in that version and look, what link 
information are actually generated. Below the list in that dialog you 
read 'Source file', 'Element' and 'Type'.




The only thing that's changed is that we've since upgraded from
Libreoffice 4 to version 5.

Are you aware of (a) the relevant change, and (b) a remedy to this
problem, so that we can use DDE links as we used to with Libreoffice
5.1.2?


I have tested it with a current developer built from master. 
[http://dev-builds.libreoffice.org/daily/] Perhaps you try such version too.


I am not aware of any relevant changes. If you can reproduce the problem 
with a small pair of test documents, then please write a bug report and 
attach the documents.


Kind regards
Regina



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Err:504 with DDE links since LO 4→5 upgrade

2016-04-20 Thread martin f krafft
Hey list,

We're dealing with a complex document containing hundreds of DDE
links. Worse yet, those DDE links are dynamically created, e.g.
using the following formula to reference filename ($B$2), sheet name,
($B$3), column ($B$6), and row (in column $A starting at $A8):

  =DDE("soffice";
CONCATENATE("file:./";$B$2);
CONCATENATE("$";$B$3;".$";$B$6;"$";$A8);
0)

This worked very well a year ago, but when we tried to open it as of
late, we get "Err:504" (parameter list error) all over.

The only thing that's changed is that we've since upgraded from
Libreoffice 4 to version 5.

Are you aware of (a) the relevant change, and (b) a remedy to this
problem, so that we can use DDE links as we used to with Libreoffice
5.1.2?

Thanks,

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
http://www.transnationalrepublic.org/
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted