One recommendation was that I upgrade to a newer LibreOffice and see if that fixes the problem.
I have Ubuntu 14.04 as dual boot on this machine, so I booted into it and ran upgrade, which I hadn't done for some months. After about an hour all the upgrades were done and I tried LO. I set up three .xls files, 1.xls, 2.xls, and 3.xls. In A1 of 1.xls I entered 1. In A1 of 2.xls I entered 2. In 3.xls I hit = , switched to A1 of 1.xls, switched back to 3.xls and continued the formula with + , switched to A1 of 2.xls, switched back to 3.xls and clicked the check icon to complete the entry. The correct value if 3 showed in A1. The formula was correct. I saved and closed all three files. I opened 3.xls again and found the duplicated bits in the formula. Back to Ubuntu 12.04, I tried doing the exercise in Excel on a virtual machine. It worked as expected, both initially, and after reopening 3.xls. I stored these in the directory shared with Ubuntu. When I opened 3.xls with LO the value in A1 was correct. But, when I saved and reopened the spreadsheet the duplication problem returned. Here's the formula: ='file:///home/rsteff/Documents/VM-Shared-Folders/Win2k-Shared/home/rsteff/Documents/VM-Shared-Folders/Win2k-Shared/1.xls'#$Sheet1.$A$1+'file:///home/rsteff/Documents/VM-Shared-Folders/Win2k-Shared/home/rsteff/Documents/VM-Shared-Folders/Win2k-Shared/2.xls'#$Sheet1.$A$1 You'll note that the path is repeated, starting with /home. So, for whatever reason, LO is duplicating the directory part of the path when it saves the file. Perhaps I should try the LO forum and see if it's a bug that needs reporting. I would imagine this is a not uncommon thing to do, so I'd expect it to have been reported by now, but I should at least check. -- Regards, Dick Steffens _______________________________________________ PLUG mailing list PLUG@lists.pdxlinux.org http://lists.pdxlinux.org/mailman/listinfo/plug
