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

[Andreas Säger]

Am 20.04.2016 um 17:21 schrieb martin f krafft:
> also sprach Andreas Säger  [2016-04-20 17:11 +0200]:
>> Works for me. DDE works with system notation ("C:\path name\file
>> name.ods") and with URL notation
>> "file:///C:/path%20name/file%20name.ods". Try the system notation.
> 
> For testing purposes, I made a copy of the file and used the
> absolute path in system notation. The result is the same.
> 
> I did notice that — with relative or with absolute paths — that the
> DDE() calls work in some contexts, but not in others. It seems very
> very brittle and I cannot figure out why.
> 

Avoid all special characters in path names, i.e. all sorts of quotes.

>> Call menu:Edit>Links to inspect links and delete unused links.
> 
> See my other question on the list: There are thousands of unused
> links there and I can't delete them other than individually, which
> can't be the solution.
> 

It's a heavy misuse of spreadsheets.

> I wouldn't be surprised if Libreoffice just can't handle all these
> inactive links and chokes.
> 

No spreadsheet can deal with that properly.


-- 
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

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

[martin f krafft]

also sprach Andreas Säger  [2016-04-20 17:11 +0200]:
> Works for me. DDE works with system notation ("C:\path name\file
> name.ods") and with URL notation
> "file:///C:/path%20name/file%20name.ods". Try the system notation.

For testing purposes, I made a copy of the file and used the
absolute path in system notation. The result is the same.

I did notice that — with relative or with absolute paths — that the
DDE() calls work in some contexts, but not in others. It seems very
very brittle and I cannot figure out why.

> Call menu:Edit>Links to inspect links and delete unused links.

See my other question on the list: There are thousands of unused
links there and I can't delete them other than individually, which
can't be the solution.

I wouldn't be surprised if Libreoffice just can't handle all these
inactive links and chokes.

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
too many have dispensed with generosity in order to practice charity.
 -- albert camus
 
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

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

[Andreas Säger]

Am 20.04.2016 um 15:43 schrieb 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,
> 

Works for me. DDE works with system notation ("C:\path name\file
name.ods") and with URL notation
"file:///C:/path%20name/file%20name.ods". Try the system notation.
Call menu:Edit>Links to inspect links and delete unused links.


-- 
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