Re: [Libreoffice] Fwd: [tdf-discuss] Problem with linking external sheets in CALC
On Tue, 2011-02-08 at 23:16 -0500, Kohei Yoshida wrote: > On Mon, 2011-02-07 at 20:19 +0700, Nguyen Vu Hung wrote: > > Hi OP and Kohei-san, > > > > FYI, consider this as a nasty hack or a bug? > > Well, if the sheet name of an external document changes, of course it > will break links. Nothing we can do about that. > > > Is there any faster way how to update these broken links? > > Perhaps you could try search and replace and replace the sheet name > globally. After that (or even before the search & replace) you can > delete the old linkage from the Edit - Links... dialog. The new link > gets established as soon as the first cell gets fetched from the > external doc. Ah wait. That's a wrong suggestion. Try updating the link in the Links dialog instead of removing it. Removing the link probably causes all the associated formulas to become values. So, first do the search and replace of the sheet names, then update the link. That *might* work. Kohei -- Kohei Yoshida, LibreOffice hacker, Calc ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
Re: [Libreoffice] Fwd: [tdf-discuss] Problem with linking external sheets in CALC
On Mon, 2011-02-07 at 20:19 +0700, Nguyen Vu Hung wrote: > Hi OP and Kohei-san, > > FYI, consider this as a nasty hack or a bug? Well, if the sheet name of an external document changes, of course it will break links. Nothing we can do about that. > Is there any faster way how to update these broken links? Perhaps you could try search and replace and replace the sheet name globally. After that (or even before the search & replace) you can delete the old linkage from the Edit - Links... dialog. The new link gets established as soon as the first cell gets fetched from the external doc. > Or could someone to make a sugestion to the developers to fix it So, what's broken in the current implementation? Kohei -- Kohei Yoshida, LibreOffice hacker, Calc ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
[Libreoffice] Fwd: [tdf-discuss] Problem with linking external sheets in CALC
Hi OP and Kohei-san, FYI, consider this as a nasty hack or a bug? -- Forwarded message -- From: OBUTEX/Hladůvka Date: 2011/2/7 Subject: [tdf-discuss] Problem with linking external sheets in CALC To: disc...@documentfoundation.org I have linked to file1.ods another file2.xls sheet named RATES and have a lot of formulas using the RATES cells. Now the name RATES in the file2.xls changed to SHEET1 and the links are broken (caused by exporting data in xls format from some other application). There is a way to change the filename but not the sheetname. I solved it by this complicated way: 1) rename the file file1.ods to file1.zip 2) unzip file1.zip to the folder "file1" 3) manualy edit the content.xml file in the folder "file1: - find the proper "xlink" tag and change "RATES" into "SHEET1" 4) zip the folder to FILE1.zip 5) rename FILE1.zip to FILE1.ods When linking the file for the very 1st time and more sheets are found in the linked file, the system asks which sheet is to be linked. This should be asked when changing the name of the linked file, too. Is there any faster way how to update these broken links? Or could someone to make a sugestion to the developers to fix it - my English is not good enough to explain the problem better :) -- OBUTEX spol. s r.o. Ing. Jiří Hladůvka Zlatovská 22 911 05 Trenčín EU Slovakia -- mailto:ad...@obutex.com http://www.obutex.com -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Archive: http://listarchives.documentfoundation.org/www/discuss/ *** All posts to this list are publicly archived for eternity *** -- Best Regards, Nguyen Hung Vu [aka: NVH] ( in Vietnamese: Nguyễn Vũ Hưng ) vuhung16plus{remove}@gmail.dot.com , YIM: vuhung16 , Skype: vuhung16plus ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice