Issue 118320 - If 2 xls spreadsheets have links to each other then a spurious #REF is reported
Summary: If 2 xls spreadsheets have links to each other then a spurious #REF is reported
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.3 RC10
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-07-21 13:06 UTC by pchinn
Modified: 2013-10-06 09:21 UTC (History)
2 users (show)

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

Attachments
ODS sheet A as described (8.66 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-07-21 13:06 UTC, pchinn 		no flags Details
ODS sheet B (8.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-07-21 13:07 UTC, pchinn 		no flags Details
XLS sheet A (6.50 KB, application/vnd.ms-excel)
2011-07-21 13:07 UTC, pchinn 		no flags Details
XLS sheet B (6.50 KB, application/vnd.ms-excel)
2011-07-21 13:08 UTC, pchinn 		no flags Details
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 pchinn 2011-07-21 13:06:07 UTC 
Created attachment 76711 [details]
ODS sheet A as described

If 2 xls spreadsheets have links to each other then a spurious #REF is reported

A cell (x) in Spreadsheet A has a link to a cell in Spreadsheet B

If a another cell in Spreadsheet B refers to x in Spreadsheet A then this cell reports a #REF error if the sheets are saved as xls.  If they are saved as ods then everything is fine.

I believe the problem arrived with 3.3.

Attached are simple demonstration sheets in ODS and XLS form.
Comment 1 pchinn 2011-07-21 13:07:08 UTC 
Created attachment 76712 [details]
ODS sheet B
Comment 2 pchinn 2011-07-21 13:07:51 UTC 
Created attachment 76713 [details]
XLS sheet A
Comment 3 pchinn 2011-07-21 13:08:18 UTC 
Created attachment 76714 [details]
XLS sheet B
Comment 4 Oliver-Rainer Wittmann 2012-06-13 12:26:05 UTC 
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 5 Edwin Sharp 2013-10-06 09:21:40 UTC 
As given in description. Cell A6 in Test B.xls is #REF!

Rev. 1525015 Win 7