Issue 125304 - Referencing a cell in another file results in #REF
Summary: Referencing a cell in another file results in #REF
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 4.1.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-07-24 15:27 UTC by wkweichert
Modified: 2014-07-24 15:27 UTC (History)
0 users

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description wkweichert 2014-07-24 15:27:37 UTC 
In file Feb14.ods I reference a cell in file Jan14.ods with the statement
=B5+'file:///C:/Users/Wolfgang/Documents/Expenses/Jan14.ods'#$'Monthly Total'.E5-D5

This results in a #REF referencing error. It happens on both Windows 8.1 and Mac OS X 10.9.1

The file Jan14.ods and the referenced cell exist. I have even gone to the extent of opening both files, moving the cursor to the appropriate cell in the referenced file, and I still get the same error.

It works correctly in Excel.