To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=100416
Issue #|100416
Summary|External area reference breaks if linked document is u
|pdated but does not exist.
Component|Spreadsheet
Version|OOO310m5
Platform|All
URL|
OS/Version|All
Status|NEW
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|open-import
Assigned to|spreadsheet
Reported by|er
------- Additional comments from e...@openoffice.org Fri Mar 20 12:39:16 +0000
2009 -------
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.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
