[PLUG] LibreOffice Calc External Reference Problem

[website reader]

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.

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?

My linux is openSuse v13.2 on a 64 bit Intel multiprocessor.

Randall

On Tue, Feb 10, 2015 at 6:05 PM, Dick Steffens <dick at dicksteffens.com>
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
> PLUG at lists.pdxlinux.org
> http://lists.pdxlinux.org/mailman/listinfo/plug
>