If you have broken links in your sheet, when LibO open your file, it ask you links to other files should be updated.
Steps to reproduce:
- create a new Calc file
- add data in Sheet1
- in Sheet2, insert link such as: =Sheet1.A1
- in Sheet1, remove lines with the data
=> in Sheet2, there is a reference error with #NAME ? (normal behavior)
- save your file
- reload it
=> LibO ask "This file contains links to other files. Should they be updated?"
In command Edit > Links, you get all links created (one per reference error).
You may simply ignore this message, but it is quite disturbing. File content is not affected, as OOo can open and does not find any link.
Yup, this isn't good.
I'll take a look at this.
Fixed on the libreoffice-3-3 branch.
Calc was previously parsing the invalid ref string as a valid external range name, which invoked the external link update dialog. OOo does not yet support external range names, which is the reason why it wasn't affected.
Verified - Closed - Sophie