Bug 60672

Summary: FILEOPEN INSERT 'Link to external data' The link could not be updated.
Product: LibreOffice Reporter: joaquin <narebeestjes>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE QA Contact:
Severity: minor    
Priority: medium CC: jmadero.dev
Version: 4.0.0.3 release   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:
Attachments: LO-4.0 load data from external link

Description joaquin 2013-02-11 15:18:19 UTC 
Created attachment 74619 [details]
LO-4.0 load data from external link

All links to load data from websites are not showing that loaded data since upgrading toe LO 4.0.

Workaround:
-> Edit -> Links -> select a link and chose [Modify]
  It appears that there is a new difference between the following choices 
  under "Available tables/ranges"

  HTML_all
  HTML_tables

The first selection displays "The link could not be updated.", the last one works in most cases.

Examples:
The following links will only show with "HTML_all"

https://www.asnbank.nl/asnappl/scripts/koersen/koersen.asp
http://www.cs.vu.nl/~x/knipselkrant/ag-128.html

The following link will never show:
http://www.zeit.de/gesellschaft/2013-02/papst-benedikt-ruecktritt
Comment 1 psmits 2013-04-06 23:43:00 UTC 
I have the same problem with one of my spreadsheets. The solution might be reported here (I'm not a programmer)
http://www.mail-archive.com/libreoffice-bugs@lists.freedesktop.org/msg86158.html

version 3.6.5.2
const ScRangeData* p =
pNames->findByUpperName(ScGlobal::pCharClass->uppercase(rAreaName));

version 4.0.1.2
const ScRangeData* p = pNames->findByUpperName(rAreaName);

Best regards.
Comment 2 psmits 2013-04-06 23:45:12 UTC 
BTW The latest version my spreadsheet worked was Calc build 3.6.5.2.
Comment 3 Joel Madero 2013-04-14 17:01:50 UTC 
Usually this would be marked as the NEW bug but the duplicate bug has been bibisected and has additional information. Marking this as a duplicate of #63407

*** This bug has been marked as a duplicate of bug 63407 ***

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.