Issue 118221 - External web reference to Calc sheet no longer works
Summary: External web reference to Calc sheet no longer works
Status: CLOSED IRREPRODUCIBLE
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
Calc sheet with external reference (6.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-06-27 15:10 UTC, eymux2009 		no flags Details
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 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 http://hg.services.openoffice.org/OOO340/rev/428b3da4b483.
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.