Description: Edit "Links to External Files..." Shows: Source File, Element, Type, Status, but it doesn't show from where is requested. Some times the Source File Link is called by a formula where the "file:///" or any other way to call for a File link is not Stated, because it might be called by an "indirect()" formula. You can Break the Link as many times as you want, but every time that you open the file again, it will call it again, because is in a formula in the file. It would be "nice" to be able to find All or at least the first call of the File Link. It happens to me in Calc, but I guess is the same on all the components Steps to Reproduce: 1.Link a file to a document 2. Go to "Edit "Links to External Files..."" look for the source of the Link File 3. Try to find it from the Edit Links Actual Results: Shows the sourced file Expected Results: Would like it to also show From where the Link was called. To sometimes, try to fix the link Reproducible: Always User Profile Reset: No Additional Info: Have an option to show from where the link was called, or just show the firs occurrence
Created attachment 178155 [details] Edit -Links to External Files -Edit Links -Source Cell Unknow On the Error Message, it shows some kind of description, indescifrable, but also would be good if it showed from where the Link to external file is called. On the Edit Links window, it shows columns: "Source file", "Element", "Type", "Status" On those columns it could be added something like "First Call" with some description like "Sheet1:B5" You have the option to "Modify..." "Break Link" "Update" "Close" It should be added and option to request to show "All" the calls to the Linked file/s.
Created attachment 178559 [details] Shows the "Edit Links" screen, no option to find cell "from where" the request was made On the Edit Links screen, you have the option to see the Source File (from where is the requesting link taking the data). But there is no option to see "From Where" the request was done. From wich cell is this request coming? It might have one request or hundreds, but there is no way to know "from where" that call was made. It would be good to have a way to "List" from wich cells the calls were made. On the screen shot you can see a Source File named "3", but in the same screen is supposed to show the Full Source Path with the full file name including the extension. On that section it only shows "3" with no Path and no extension, just "3". I'm looking for a way to find from where is that file called, and get rid of it. Somewhere in the Sheet is a "wrong" call that I would like to find and discard. It would be nice to have, also for troubleshooting and improving the sheet "coding".
Thanks for the suggestion. I was trying to recreate an example file but couldn't (I could always break the link). Could you please attach a sample file? Thank you!
Dear G, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear G, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp
Created attachment 196292 [details] 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."
Created attachment 196293 [details] The Second file