Re: [PLUG] LibreOffice Calc External Reference Problem

2015-02-12 Thread Dick Steffens
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 thr

Re: [PLUG] LibreOffice Calc External Reference Problem

2015-02-10 Thread Dick Steffens
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

Re: [PLUG] LibreOffice Calc External Reference Problem

2015-02-10 Thread 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 fil

[PLUG] LibreOffice Calc External Reference Problem

2015-02-10 Thread Dick Steffens
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