Issue 100416 - External area reference breaks if linked document is updated but does not exist.
Summary: External area reference breaks if linked document is updated but does not exist.
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO310m5
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: regression
Depends on:
Blocks: 95768
  Show dependency tree
 
Reported: 2009-03-20 13:39 UTC by ooo
Modified: 2013-08-07 15:14 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description ooo 2009-03-20 13:39:16 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.
Comment 1 ooo 2009-03-20 13:41:12 UTC 
Regression, working on this, nominating as 3.1 blocker.
Comment 2 ooo 2009-03-20 13:48:31 UTC 
Grabbing.
Comment 3 ooo 2009-03-20 14:29:40 UTC 
In cws calc31stopper4:

revision 269808
sc/source/core/tool/compiler.cxx
Comment 4 ooo 2009-03-20 15:42:42 UTC 
Reassigning to QA for verification.
Comment 5 oc 2009-03-24 13:09:42 UTC 
verified in internal build cws_calc31stopper4
Comment 6 amy2008 2009-04-01 09:11:00 UTC 
The formula itself is =SUM('extern.ods'#Sheet1.A1:A2), works well.
Verified in OOo310m7 on WinXP and Fedora9.
Closing
Li Meiying
Comment 7 amy2008 2009-04-01 09:25:04 UTC 
Sorry, I checked it in OOo310m8, not OOo310m7