Bug 100093

Please attach example document.

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.

Created attachment 125421 [details]
Error Message

Error message generated upon opening main SS which has many links to external SS's. All SS's are in the same directory.

I mean the document, not a screenshot.

Not sure what you need an example document of? I've attached the error message though.

As shown in the attachment, the error is the number of times the path is appended to with additional "/home/jim/Documents/My Spreadsheets/Spreadsheets 16/".

When I xferred the spreadsheets from my Win10 HDD, those links were working fine.

I have found a work around. Turns out that Calc does not like the Directory structure. The dir tree was a copy of the old dir tree on my Win10 HDD as I copied and pasted onto the Ubuntu HDD.

In order to solve the problem, I created a new directory: "Home/jim/Documents/Spreadsheets/" and placed copies of all my SS's there. Then I changed the pointers in the cells and it worked. Changing 'Path' in 'Tools' 'Options' never seemed to make any different with the error.  

In other words, Libre Calc does not like the path(s) I was using. 

This works: 'file:///home/jim/Documents/Spreadsheets/'
Doesn't work: 'file:///home/jim/Documents/My Spreadsheets/Spreadsheets 16/'

Now that I know what the problem is, I'll mess with paths until I find something that works for me.

(In reply to Jim@HiTek from comment #4)
> Not sure what you need an example document of? I've attached the error
> message though.

In every case that there is a problematic document, we need it to examine the problem.

Created attachment 125424 [details]
Spreadsheet in the ODS format that does have the problem.

In order to recreate the problem, there are 4 spreadsheets. Two of them will call (link to) data. The 3rd and 4th will just store that data. Two are saved as ODS documents, and two are saved as XLS documents. I imported them all of my original SS's from a Win10 machine and they are all XLS extensions. I'll try to send the four SS's I created for the test but right this bug report form seems to only allow one attachment at a time.

You'll have to edit the two files MainTest files to put in the appropriate path on your computer. I'm new to Ubuntu and I'm still learning the path structure. I created the files and put them in a directory as close to root as I could in their own folder called TestSSFolder directly under 'Home' but the links added 'Jim' as part of the directory path. So you'll have to set up yours on your own.

I have found from testing that the XLS sheets are the ones that keep appending to the paths in the links. The ODS sheets don't do that. 

I do want to keep my SS's as XLS in order to be able to easily go back and forth between my computer and my clients computers. Most of which still use the old XLS formatting.

Three more files to follow...

Created attachment 125425 [details]
ODS Libre SS

SS #2 attachment with the ODS extension.

Created attachment 125426 [details]
Test link with the ODS extension.

3rd of 4 attachments. This is the file linked to by the MainTest.XXX files. It carries the ODS extension.

Created attachment 125427 [details]
Test link with the XLS extension.

4th of 4 attachments. This Test link carries the XLS extension.

I failed at proof reading...sorry.

The FIX was to open the main SS with it's XLS extension using Libre, then save it with a Libre ODS extension. Then when I opened that SS, and it asked me if I'd like to import the data from the other SS's (all with XLS extensions), it works fine.

It fails when I use Libre to open the main SS with the XLS extension. Asks me if I'd like to import, when I try that, it's giving me that error and repeatedly appends the path.

Received an em notice that this bug had an added "needAdvice" notification. I don't know what that means or who generated it.

I haven't changed the status of this bug as it's still a bug.

To Recreate the bug using LibraOffice Calc: 

1) Name or import a SS with a XLS file name extension (Ex: Expenses.xls), 

2) create another SS with either a xls or ods extension, (Ex: Gas.xls), 

3) In Expenses, set up cell(s) which link to Gas.xls (or Gas.ods), enter numeric data in the external cell(s),

3) than save the SS's.

Click to reopen Expenses.xls, it will ask if you wish to update links to other files. Click 'Yes'. It will give an error message "The following external file could not be loaded. Data linked from this file did not get updated."

The error will be generated because Calc appends the path to the external cell each time the SS is closed than opened.

Perhaps the problem is the space (actually the two spaces) in the problematic directory structure: 

Jim@HiTek said that the path without spaces, that is, 
'file:///home/jim/Documents/Spreadsheets/' worked fine
while the original path with the spaces didn't 
'file:///home/jim/Documents/My Spreadsheets/Spreadsheets 16/'

(In reply to Carlos from comment #12)
> Perhaps the problem is the space (actually the two spaces) in the
> problematic directory structure: 
> 
> Jim@HiTek said that the path without spaces, that is, 
> 'file:///home/jim/Documents/Spreadsheets/' worked fine
> while the original path with the spaces didn't 
> 'file:///home/jim/Documents/My Spreadsheets/Spreadsheets 16/'

I created a test from scratch with such a directory structure having nested folders with spaces in them. No problem.

Tested saving and reloading multiple times.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha0+
Build ID: 86eb71c4789dc5ab0200f49f7e5bca512ef4adaf
CPU threads: 8; OS: Linux 4.10; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on April 12th 2016

I think the easiest way to fix the problem is:
1/ configure LO to save links as relative paths: menu Tools > Options > Load/save > General
2/ to modify the links in menu Edit > Links... -> for each link click Modify button and choose the correct file in the current directory.
3/ save and close LO

Then you can check that your files open fine even if you move the three files in another directory.

Does that fix the problem for you?

Set status to NEEDINFO, please set it back to UNCONFIRMED once requested
informations are provided.

Best regards. JBF

Dear Bug Submitter,

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-20180502