[Libreoffice-bugs] [Bug 124461] Creating workbook to workbook links no longer simple.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124461

--- Comment #2 from Bob <bob at telpro.co.za> ---
Hi,

Been doing some experiments to determine the cause of the issue, as yes you
quite correct, it seems to work sometimes. 

1. If you have a lot of links to an external file. The File becomes unstable
and sometimes crashes. 
2. Creating the external reference file as an XLSX file seem to be less
problematic than an ODS file.
2.1 Creating the link by pointing to the cell in the reference file, creates a
file://url/worksheet/sheet/"cell reference" If you now save and close  the
Calling file and reopen. You get several strange behaviors.
1. Cell shows #REF or #Value. Looking at the cell reveals the correct syntax,
however the cell still shows an error. If you now re-point to the cell you
require, the syntax and formulae do not change but the error disappears.  
2.Some cells have data from the incorrect sheet in the reference file but the
correct Cell reference. example If you have two sheets in the reference file.
lets call them One and Two. You have an external link that says sheetONE cell
D2. Data that shows in that cell is data from  SheetTwo D2. 
3.The link is not dynamic. If you make changes in the reference file the data
does not change in the calling file.

The files I have are rather large and have confidential data, else I could send
them to you, can do but not on a public link, I think you can appreciate that.
When I get 30 minutes will see if I can create some dummy files, that exhibit
the same problems to assist you. 

Interestingly opening the calling file (XLSX format) in xcel takes 53 seconds 
In libra this takes 15 minutes and shows no errors. Opening the  file (ODS
format)the XLSX file saved as ODS from Libra, shows only #REF errors or data
from wrong sheets in the called file data.

I will try save the XLSX file from XCEL in ODS format and see if I get the same
errors.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190402/5844bd68/attachment-0001.html>