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 <kyosh...@novell.com> _______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
