[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 --- Comment #17 from gra...@harris.net.nz --- Bump. Any ideas? -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 --- Comment #16 from gra...@harris.net.nz --- When I look at content.xml inside the 'master' spreadsheet I see repeated references to the subsidiary spreadsheets (without any path information). I never find any references to the word Documents (as in my $HOME/Documents/) nor to the word projects (as in my $HOME/projects/killigray/energy/insolation/ which is where all the files actually are). So I presume m.a.riosv is correct in saying that LibreOffice stores relative paths; which in this case is evaluated and saved as 'nothing' since they are in the same directory. Therefore, something in the LibreOffice code is referring directly to $HOME/Documents as a default location to look in, ahead of the master spreadsheet's current directory. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 --- Comment #15 from gra...@harris.net.nz --- "LibreOffice always shows the full path, even relative path is saved." I don't understand this comment in context. I don't know what path LibreOffice actually saves, all I can say is that is expects (on opening) these files to be in my $HOME/Documents/ whereas they only ever exist in my $HOME/projects/killigray/energy/insolation/ (where the spreadsheet that gets data from them lives also). If it were correctly saving the relative path, then it would not generate these errors on opening the spreadsheet because, relative to the spreadsheet being opened, these subsidiary spreadsheets are actually in the same directory. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 --- Comment #14 from m.a.riosv --- LibreOffice always shows the full path, even relative path is saved. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 --- Comment #13 from gra...@harris.net.nz --- Further to this report: If I use the Edit; Links to External Files and use the Modify button, I can select the same named file in the current directory BUT clicking Insert (closing the Modify dialog) take me back to the Links to External Files dialog, which still shows the full path as being my $HOME/Documents/ rather than the actual directory. If I close the Links to External Files dialog and reopen it that linked file is now shown as being in the correct location, but the other files are still shown as being in my $HOME/Documents/. If I now save the file, restart LOCalc and open the spreadsheet again, I STILL get the error on opening, from the file where I previously selected that file in my data directory- the error says it is in my $HOME/Documents/ along with the others I did not change. And going back to the Links to External Files dialog, this file is still shown there as being in my $HOME/Documents/ So I really do not believe this bug report should be closed without a fix. What more information can I supply to help the team find the error? Thanks Graham -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 --- Comment #12 from gra...@harris.net.nz --- Created attachment 191662 --> https://bugs.documentfoundation.org/attachment.cgi?id=191662=edit Screenshot of Edit; Links to External Files dialog -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 gra...@harris.net.nz changed: What|Removed |Added Status|RESOLVED|REOPENED Ever confirmed|0 |1 Resolution|NOTABUG |--- --- Comment #11 from gra...@harris.net.nz --- Thanks for taking an interest, but this advice is just what I can do to make the error messages go away. It does not address how the errors arose, so the bug is not fixed. Also, the method proposed in the advice gives a nice route to breaking the spreadsheet concerned. In the dialog where I am advised to remove the links, there is no clue where the links are in the spreadsheet and therefore, what I should expect them to do. Only by trial and error, will the user find out whether the calculation involving the links is now broken. Perhaps the cell reference is in the Element column of that dialog box? There is nothing in that column for me, is that evidence that there is somehow a link to the file but not to anything in the file? I will try to add a screen grab to show this. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 raal changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED CC||r...@post.cz Resolution|--- |NOTABUG --- Comment #10 from raal --- Hello, if I understand correctly the discussion, we can close the bug. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 --- Comment #9 from m.a.riosv --- If you select modify in edit-links, you can select again the file, without break the link. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 --- Comment #8 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 --- Comment #7 from gra...@harris.net.nz --- Created attachment 191555 --> https://bugs.documentfoundation.org/attachment.cgi?id=191555=edit Menu; Edit; Links to external files This is what I see when I go to Edit; Links to external files. In each case only the file name is shown in the list but when expanded below the /home/graham/Documents/ is prepended. If I 'Break Link' on one of the external files, then save and exit, when I re-open the file then I am not prompted regarding that file any more (as expected). And the data in the column which is supplied by the file of the same name in the current directory (same as the 'master' spreadsheet) is still there in the master, so clearly it is coming from the correct sub-sheet, not the phantom in /home/graham/Documents/ So for me, I can resolve this issue just by breaking all the links, and I knew that. I am just bringing this up as a bug so that no-one in future needs to go through the troubleshooting exercise. Thanks! -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 --- Comment #6 from m.a.riosv --- Maybe, but you can go Menu/Edit/Link to external data - Select Modify and selecting again the file. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 --- Comment #5 from gra...@harris.net.nz --- Thanks for giving this some attention. I have checkmarks next to both "Save URLs relative to filesystem" and "Save URLs relative to internet", and I have certainly saved the file since that was set. It is possible that I first saved the file with that not set, but I have no way to go back and check. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #4 from m.a.riosv --- Test if it is related to: Menu/Tools/Options/Load/General - Save URLs relative to file system. Maybe you have save the file with the option disable. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 --- Comment #3 from gra...@harris.net.nz --- Tools; Options; LibreOffice; Paths, My Documents is set to /home/graham/Documents -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 --- Comment #2 from gra...@harris.net.nz --- Created attachment 191554 --> https://bugs.documentfoundation.org/attachment.cgi?id=191554=edit one of the subsidiary spreadsheets on the same directory as the master This data shows up in the master spreadsheet Sheet1 column F. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158816] Dependence on ~/Documents
https://bugs.documentfoundation.org/show_bug.cgi?id=158816 gra...@harris.net.nz changed: What|Removed |Added CC||gra...@harris.net.nz --- Comment #1 from gra...@harris.net.nz --- Created attachment 191553 --> https://bugs.documentfoundation.org/attachment.cgi?id=191553=edit master spreadsheet demonstrating the problem -- You are receiving this mail because: You are the assignee for the bug.
