This bug has been around for more than a half decade.
For files files with no External Links, Calc gives the Security Warning Automatic update of external links has been disabled.
xx2.ods (6.9 KB)
Bug???
You have Links to External Files (that you mentioned), giving you a dialog to review and, if needed, break the links. What is wrong using the existing tools, as opposed to hacking XML?
1 Like
As a user, the hack to fix such a file:
- use Edit > Links to External Links to find the offending Source file and jot that down
- copy the problematic ods to, say, xx.ods
- unzip xx.ods
- open content.xml in a text editor
- look for xlinks and identify the offending one
- delete the self-closing <table …/> that encloses it
- save the edited file
- recompress the components into a new ods
- open the new ods
- if necessary, run a global all-sheet search&replace of \n with ‘’
For unzipping and recompressing, see my notes here:
.
https://ask.libreoffice.org/t/calc-how-do-i-reduce-ods-file-size-by-resizing-embedded-images/131739/5
For those who follow, here are a few related threads:
.
Oct 2023 https://ask.libreoffice.org/t/calc-external-links-warning-but-search-for-file-does-not-find-any-links/97286/10
.
Sep 2021 https://ask.libreoffice.org/t/calc-document-thinks-there-is-an-external-link-but-there-is-not/68548/4
.
Sep 2021 https://ask.libreoffice.org/t/document-has-no-links-but-i-get-automatic-update-of-external-links-has-been-disabled/68350/6
.
Jun 2020 https://ask.libreoffice.org/t/how-to-find-external-links/54273/12