On 02/10/2015 08:15 PM, website reader wrote: > Dick: > > First of all, I had to save the LibreOffice files in MS 2003 xls format not > the default .ods format, and 2.xls is superfluous here in the discussion.
Yes. I exchange data with older Excel users, (that's older Excel, not older users) so I have my default set to .xls. > and 2.xls is superfluous here in the discussion. True. I was going to fill out the example in a way that modeled what got me started on it, which does involve two source files and one destination file. But since the problem showed up with just one reference I didn't bother finishing the example. > Using Libre Office, version 4.3.5.2.0+ Build ID 430m0(Build:2) shows no > problem, when 3.xls is re-opened, it popped up a box asking for a file > link > renewal, and I clicked okay. > > The value in the call is still 'file:///home/owner/1.xls'#$'1'.A1 with > value 1 from 1.xls. > > What version of Libre Office are you using? 3.5.7.2, Build ID: 350m1(Build:2) > My linux is openSuse v13.2 on a 64 bit Intel multiprocessor. Ubuntu 12.04 on an Intel(R) Core(TM) i3-4130 CPU @ 3.40GHz > Randall > > On Tue, Feb 10, 2015 at 6:05 PM, Dick Steffens <[email protected]> > wrote: > >> LibreOffice Calc is duplicating some of the link information when try to >> import data from one spreadsheet to another. >> >> Example: >> >> I create three xls files, 1.xls, 2.xls, and 3.xls. >> >> I enter the value 1 in cell A1 in file 1.xls. I enter the value 2 in >> cell A1 in file 2.xls. >> >> I file 3.xls in cell A1 I hit =, switch to file 1.xls, click in cell A1, >> return to file 3.xls, and click the check mark. The value 1 from cell A1 >> in file 1.xls now appears in cell A1 in file 3.xls. The line that shows >> the formula for that cell contains the following: >> >> ='file:///home/rsteff/Desktop/1.xls'#$Sheet1.A1 >> >> Looks correct. But, if I close file 3.xls and reopen it, the formula in >> cell A1 now reads: >> >> ='file:///home/rsteff/Desktop/home/rsteff/Desktop/1.xls'#$Sheet1.A1 >> >> Note that /home/rsteff/Desktop is repeated which, of course, doesn't >> exist and which sets of an error dialog box. >> >> Has anyone had this problem? Did you find a solution? >> >> (There would be a 2.xls with something else in A1 which would be added >> in A1 of 1.xls in 3.xls, but not until I solve this problem first.) >> >> -- >> Regards, >> >> Dick Steffens >> >> _______________________________________________ >> PLUG mailing list >> [email protected] >> http://lists.pdxlinux.org/mailman/listinfo/plug >> > _______________________________________________ > PLUG mailing list > [email protected] > http://lists.pdxlinux.org/mailman/listinfo/plug > -- Regards, Dick Steffens _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
