https://bugs.documentfoundation.org/show_bug.cgi?id=146723
G <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #6 from G <[email protected]> --- Created attachment 196292 --> https://bugs.documentfoundation.org/attachment.cgi?id=196292&action=edit Two files Linked by Manual Link, Paste Special As Link, Indirect Two Files, "From.xlsx" and "To.xlsx" In "From" file there is a text in B2 that says "Origin" In "To" are four different ways to link the two files. What I would like to have as a Tool, is a way to know from which Cell and Sheet was the "call" made from, something showing a list of Cells from where each call was made. So in the list would show something like on the screen from, "Find and Replace" result screen when you do something like serching "=", on the "Search Results" will show "Sheet" "Cell" "Content" On File "From" B2: "Origin" On File "To" B1: ='file:///Users/From.xlsx'#$Sheet1.B2 B3: =IFERROR(INDIRECT($F$25&"B"&INDIRECT("A"&ROW()+6)),0) B5: =IFERROR(INDIRECT($F$13&"B"&INDIRECT("A"&ROW()+4)),0) B7: {='file:///Users/From.xlsx'#$Sheet1.B2} A9: 2 F13: ="'"&LEFT(MID(F2,FIND("+|",SUBSTITUTE(F2,"/","+|",(LEN(F2)-LEN(SUBSTITUTE(F2,"/","")))))+1,LEN(F2)),SEARCH("$",MID(F2,FIND("+|",SUBSTITUTE(F2,"/","+|",(LEN(F2)-LEN(SUBSTITUTE(F2,"/","")))))+1,LEN(F2)))-1)&F17 F13: (result from the Formula: 'From.xlsx'#$Sheet1. F17: "$Sheet1." -- You are receiving this mail because: You are the assignee for the bug.
