搜索

2010年7月7日星期三

Open Office Bug ( Spreadsheet ): External references wouldn't update automatically, if you insert or delete rows

Environment:
  • 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:

    Parent Spreadsheet:

    Child Spreadsheet:

 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:
And it should show 'A2 in Parent Spreadsheet' that is 'An example'.

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!

没有评论:

发表评论