Issue 124132 - Function can not read linked data range (?) from external source (other document)
Summary: Function can not read linked data range (?) from external source (other docu...
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: PC All
: P3 Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2014-01-28 11:25 UTC by Michael Rutherford
Modified: 2014-01-28 12:40 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

XLS file containing a formula (26.00 KB, application/
2014-01-28 11:25 UTC, Michael Rutherford
no flags Details
Referenced XLSX file (8.84 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-01-28 12:09 UTC, Michael Rutherford
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Michael Rutherford 2014-01-28 11:25:05 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
Comment 1 Edwin Sharp 2014-01-28 11:31:56 UTC
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1560934
2014-01-27_04:11:25 - Rev. 1561585

OK with Calligra Sheets 2.7.5
Comment 2 Rainer Bielefeld 2014-01-28 11:59:21 UTC
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.
Comment 3 Rainer Bielefeld 2014-01-28 12:00:51 UTC
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?
Comment 4 Michael Rutherford 2014-01-28 12:09:04 UTC
Created attachment 82413 [details]
Referenced XLSX file

I've attached the missing XLSX file, in case it's needed for further debugging.
Comment 5 Rainer Bielefeld 2014-01-28 12:22:18 UTC
(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 - 

@Michael Rutherford
Thank you for the source.xls, indeed, there might be additional problems (needing additional separate Bug reports.
Comment 6 Rainer Bielefeld 2014-01-28 12:40:29 UTC
(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 
    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
Can you try to find a DUP? I did not find any, so CONFIRMED for now.