Apache OpenOffice (AOO) Bugzilla – Issue 124132
Function can not read linked data range (?) from external source (other document)
Last modified: 2014-01-28 12:40:29 UTC
Created attachment 82410 [details] XLS file containing a formula When attempting to open the attached XLS file, I get the subject error. Build installed: Apache_OpenOffice_4.1.0_Linux_x86-64_install-rpm_en-US_2014-01-27_04_11_25_1561585.tar.gz
Confirmed with AOO410m1(Build:9750) - Rev. 1560934 2014-01-27_04:11:25 - Rev. 1561585 Debian OK with Calligra Sheets 2.7.5
No Error message with "AOO 4.0.1 – German UI / German locale [Rev. 1524958 2013-09-20 11:40:29]" on German WIN7 Home Premium (64bit)", “historic” 4.0 User Profile used for all predecessor versions, but nevertheless, I see "Err:508" in the document Sheet3:B10 and others. This one needs some more investigation.
Additional Info: (a) Document contains links to data in a document "source.xls" in the same folder, what does not exist. So an error message is not too unexpected, but why can Gnumeric and MS Excel viewer open the document without problems?
Created attachment 82413 [details] Referenced XLSX file I've attached the missing XLSX file, in case it's needed for further debugging.
(b) Gnumeric in Sheet3.ColumnB shows numbers in B2:B5, but after <f2><enter> a reference error appears for the cell (c) LibO 4.1.3 knows the trick. If I try to update data from source.xls, I get a message "Update impossible", and LibO keeps values (c) Menu 'Tools -> Options -> Calc -> General - Update=never' does not help (d) So AOO should keep the cell values (what seem to exist, all other spreadsheet programs know them) Instead of trying a useless update. (e) and of course should keep the values for those cells with invalid link also if it does not try to update ('Tools -> Options -> Calc -> General - Update=never'). @Michael Rutherford Thank you for the source.xls, indeed, there might be additional problems (needing additional separate Bug reports.
(f) The longer I think about my results the more I doubt that it's a link update problem. Problem seems to be a problem with the syntax in Example: B4 (Sheet3) should contain something like "=MAX('file:///C:/Users/Public/Documents/AOOo/124132/Source.xlsx'#data)" not "=MIN(#NAME!data)" So I limit this one the "read function with link to other document" problem. Might be a problem with linked data range? Concerning further problems it might be useful to wait for a fix here. (g) and I think if there is such a syntax problem, AOO should keep the existing values instead of showing error message immediately? (h) Problem persists with .ods created from LibO (i) I think I see the same problem already in very early OOo versions (OOo 3.1.1, OOo 1.1.5) @Michal, @Edwin: Can you confirm my results to the root problem? And may be you have better ideas than me how to do research for possible additional problems? Can you try to find a DUP? I did not find any, so CONFIRMED for now.