Issue 124919 - Detective does not link correctly to another spreadsheet
Summary: Detective does not link correctly to another spreadsheet
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.0.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-05-17 02:43 UTC by TAB
Modified: 2014-05-17 02:45 UTC (History)
0 users

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


Attachments
file with formulae (8.36 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-05-17 02:43 UTC, TAB
no flags Details
contains data for DetecA formulae (7.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-05-17 02:45 UTC, TAB
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description TAB 2014-05-17 02:43:50 UTC
Created attachment 83407 [details]
file with formulae

DetecA.ods has a formula in cell A3 that refers to cell A2 and to cell C10 of another spreadsheet, DetecB. Now, with Tools/Detective, display the Precedents of A3: get A2, and C10 of DetecA, not DetecB, which is incorrect.
	This seems to be linked to the fact that A2 is contiguous with A3. A7 contains the same formula, but Detective does not show DetecA:C10 as Precedent.
Comment 1 TAB 2014-05-17 02:45:09 UTC
Created attachment 83408 [details]
contains data for DetecA formulae