Apache OpenOffice (AOO) Bugzilla – Issue 124919
Detective does not link correctly to another spreadsheet
Last modified: 2014-05-17 02:45:09 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.
Created attachment 83408 [details] contains data for DetecA formulae