Apache OpenOffice (AOO) Bugzilla – Issue 100416
External area reference breaks if linked document is updated but does not exist.
Last modified: 2013-08-07 15:14:39 UTC
A reference to an external sheet area breaks if an attempt is made to update from the referred document but that doesn't exist. Scenario to reproduce: 1. In a formula, use a reference to an area of an external document, such as =SUM('extern.ods'#Sheet1.A1:A2) 2. Rename the extern.ods file to something else. 3. Menu Edit->Links and Update. 4. The formula cell displays #REF!, which is correct. 5. The formula itself changed to =SUM('extern.ods'#Sheet1.A1:) Note the missing second corner of the reference. The reference now is broken and if saved would be lost when reloaded.
Regression, working on this, nominating as 3.1 blocker.
Grabbing.
In cws calc31stopper4: revision 269808 sc/source/core/tool/compiler.cxx
Reassigning to QA for verification.
verified in internal build cws_calc31stopper4
The formula itself is =SUM('extern.ods'#Sheet1.A1:A2), works well. Verified in OOo310m7 on WinXP and Fedora9. Closing Li Meiying
Sorry, I checked it in OOo310m8, not OOo310m7