Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index

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
2) unzip 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
5) rename 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

Unsubscribe instructions: E-mail to
*** All posts to this list are publicly archived for eternity ***


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.