https://bugs.freedesktop.org/show_bug.cgi?id=79305

--- Comment #3 from Edgar Grill <[email protected]> ---
Confirmed in LOO 4.2.3 (Windows x86)

---

Another method you could try for healing already corrupted files is to
programmatically search and replace the link targets in CONTENT.XML unzipped
from the ODS file.
This could be easily achieved massively via GNU sed (invoked by a script which
runs over a collection of files) - or by hand with any text editor - because
link target are stored in this way:

  <style:hyperlink xlink:href="protocol://target" xlink:type="simple"/>

Where "protocol" stands either for "file" or "http"
So, if we have:

  <style:hyperlink xlink:href="protocol://absolute-path/target-file"
xlink:type="simple"/>

We can easily revert it to

  <style:hyperlink xlink:href="protocol://relative-path/target-file"
xlink:type="simple"/>

By stripping away the fixed part of absolute path:

  sed -i '' 's/part-of-path-to-strip//' content.xml

in all hyperlinks included in the same spreadsheet. In order to identify the
string to strip (or modify...), you can also take a comfortable look to the XML
with a web browser.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to