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

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

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

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.

Re: [libreoffice-users] Re: Deleting external links

also sprach Andreas Säger [2016-04-20 17:20 +0200]: > DDE("soffice";"path_name","ref") and URL links > 'file:///path/name.ods'#$Sheet.A1 are established by formula > expressions. Before you can delete them in the links dialog, you > have to remove all formula references. I

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

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

[libreoffice-users] Re: Deleting external links

Am 20.04.2016 um 15:45 schrieb martin f krafft: > Hey list, > > we are dealing with a rather complex spreadsheet and looking at > Edit→Links, there are literally thousands of links in there that are > no longer used anywhere in the document. Opening the document (and > saving, and sometimes

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

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

[libreoffice-users] Deleting external links

Hey list, we are dealing with a rather complex spreadsheet and looking at Edit→Links, there are literally thousands of links in there that are no longer used anywhere in the document. Opening the document (and saving, and sometimes editing, and …) takes several minutes, and we think this is due

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

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