Spreadsheets with formulas containing names (by this i mean inserting values created using the "Insert -> Names" command), will get corrupted (returning "Err:520) if the file is exported in .xls format. This applies to .xls files created with earlier versions of LibreOffice or OpenOffice. Howevever, saving the file in .ods format the formulas will give back the right values. Opening the broken .xls with an earlier version of LibreOffice will also give right values.
Please see attachement for demostration. The .xls is with the broken values, the .ods for the right ones.
I used LO 3.4 final, both for Linux_amd64, and win_x86.
Created attachment 47862 [details]
.xls version with broken values
Created attachment 47863 [details]
.ods version with right values
It seems that the import has some more problems here. The formulas are totally messed up.
For example: =#NAME?+12*1589 instead of =12+1589*n
Let's see if I can find the problem
bubli pointed me to the nearly identical bug report for xlsx.
So it might not be an import problem but a problem in the calc core.
I have a closer look at both bugs.
Ok, at least I found the problem now.
Let's see if I find a quick and clean way to solve it.
Patch sent to the ML list and asked for sign-off into 3-4.
Will hopefully be included in 3.4.2
*** Bug 38767 has been marked as a duplicate of this bug. ***
*** Bug 38802 has been marked as a duplicate of this bug. ***
*** Bug 39398 has been marked as a duplicate of this bug. ***
*** Bug 39195 has been marked as a duplicate of this bug. ***