Issue 118221 - External web reference to Calc sheet no longer works
Summary: External web reference to Calc sheet no longer works
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOO320m19
Hardware: PC Linux, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-06-27 15:10 UTC by eymux2009
Modified: 2017-05-20 09:58 UTC (History)
3 users (show)

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

Calc sheet with external reference (6.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-06-27 15:10 UTC, eymux2009
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description eymux2009 2011-06-27 15:10:59 UTC
Created attachment 76642 [details]
Calc sheet with external reference

External references to Calc sheets in the form 

='http://<some URL>/<dok>.ods'#$Sheet1.A1

are no longer resolved. References using the file: protocol still work as expected. The bug was discovered in OOo 3.2.1, but is still present in OOo 3.4.

Steps to reproduce:
- open the attached Calc document
- click 'yes' to update the references
- the cell A1 shows the error message #NAME? (should be 'abc')
- the status line displays 'ERROR: Invalid name'
Comment 1 Oliver Brinzing 2011-06-28 10:54:21 UTC
Comment 2 niklas.nebel 2011-08-28 17:42:00 UTC
Looks related to issue 114504, which is fixed with
Comment 3 Oliver-Rainer Wittmann 2012-06-13 12:29:24 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 4 Edwin Sharp 2013-03-10 20:08:20 UTC
A1 gives #REF! as it should for a URL that gives Server not found.