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 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] 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.
>
> 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: 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 don't want to remove all links. I want to remove those links that
are no longer in use.
Here's a simple example: let's assume $A$1 has the contents
"blue.ods", and I fill $B1:$B100 with a formula along the lines of
# effectively copy 100 cells from blue.ods#Sheet 1 column B
DDE("soffice"; $A$1; CONCATENATE("Sheet 1.$B$"; ROW()))
This will generate 100 links.
Now I change "blue.ods" to "red.ods" and recalculate. Now I have 200
links, but 100 of those are no longer in use.
Does this make sense?
--
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
seen on an advertising for an elaborate swiss men's watch:
"almost as complicated as a woman. except it's on time"
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
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 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: 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 editing, and …) takes several minutes, and we
> think this is due to the sheer massive number of links.
>
> We found that links can be individually deleted (broken), but we
> were wondering if there's a way to do so in bulk? Or better yet, how
> can I automatically remove unused references in this list?
>
> Thanks for any hints,
>
There are 5 different types of spreadsheet links. Some appear in
menu:Edit>Links, database links can be organized in menu:Data>Define
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.
[Tutorial] External Links In Calc:
> https://forum.openoffice.org/en/forum/viewtopic.php?f=75&t=3294
--
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
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
[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 to the sheer massive number of links. We found that links can be individually deleted (broken), but we were wondering if there's a way to do so in bulk? Or better yet, how can I automatically remove unused references in this list? Thanks for any hints, -- @martinkrafft | http://madduck.net/ | http://two.sentenc.es/ "next the statesmen will invent cheap lies, putting the blame upon the nation that is attacked, and every man will be glad of those conscience-soothing falsities, and will diligently study them, and refuse to examine any refutations of them; and thus he will by and by convince himself that the war is just, and will thank god for the better sleep he enjoys after this process of grotesque self-deception." -- mark twain 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] 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";
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
