- Open Office 2.4
In Open Office 2.4, the external references wouldn't update automatically, if you insert or delete rows in parent spreadsheet.
Example to show the bug:
1. There are two spreadsheet, named: Parent Spreadsheet and Child Spreadsheet. And A1 of Child Spreadsheet = A1 of Parent Spreadsheet, and the content is 'An example', like below:
2. If you insert one row as 1st row in parent spreadsheet, like:
you may think the formula in Child Spreadsheet - A1, will be update as "='file:///.../parent spreadsheet.ods'#$Sheet1.A2", BUT IT WILL NOT!
In fact, the formula in Child Spreadsheet keeps as "='file:///.../parent spreadsheet.ods'#$Sheet1.A1", that cause the final result like this:
That's the problem! If there are many external references, then no user could dare to insert or delete any cell, for they don't know how many external references point to them, and need to be updated manually!