Skip to content Skip to sidebar Skip to footer
Home / Open Office "Error Reading Data From the Internet."

Open Office "Error Reading Data From the Internet."

Post a Comment

[Solved] Problem retreving data from external link

Discuss the spreadsheet application

[Solved] Problem retreving data from external link

Approximately 3 weeks agone the "link to external data" quit working in ane of my spread sheets. I've tried to replace the link with dozens of different spider web site and none of them work, I navigate to the site and re-create the addressees from the address bar then I know it'south not spelled wrong. When attempting to setup the link Calc reports "Error reading data from the internet. Server fault message." Did a windows update break this function? Is at that place a work around?

Thanks ahead of fourth dimension!!!

Last edited by Hagar Delest on Fri October 25, 2019 12:32 pm, edited 1 time in full.
Reason: tagged solved.

Windows x Open Role 4.1.7

Vancejo
Posts: 6
Joined: Thu October 24, 2019 7:13 pm

Re: Problem retreving data from external link

Postby Zizi64 » Thu Oct 24, 2019 vii:46 pm

Calc reports "Error reading data from the net.

Please share the URL-s or upload an ODF type sample file here.

Tibor Kovacs, Hungary; LO6.1.6, vi.4.7 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.three.0-7.ane.1;AOO4.one.9
Delight, edit the initial post in the topic: add the word [Solved] at the offset of the subject line - if your problem has been solved.

User avatar
Zizi64
Volunteer
Posts: 10300
Joined: Wed May 26, 2010 seven:55 am
Location: Budapest, Hungary

Re: Trouble retreving data from external link

Postby Vancejo » Thu Oct 24, 2019 7:49 pm

Windows 10 Open Part 4.1.seven

Vancejo
Posts: six
Joined: Thu October 24, 2019 7:thirteen pm

Re: Trouble retreving data from external link

Postby Zizi64 » Thu Oct 24, 2019 8:29 pm

The table on the linked site is not a HTML TABLE really, but it is a formatted textual document.
The "numeric" values are separeted with many whitespace characters, but non TAB nor other usual separator character nor html table TAGs.

What was the structure of this page in the by?

Lawmaking: Select all   Expand viewCollapse view
Kitco Inc.
Text Only Market Page

    Graphic version of this page

    Precious Metals Lease Rates
    Historical Price Information
    Precious Metals News Headlines

    Buy gold and silver online direct from Kitco!
Live quotes for all bullion products.

--------------------------------------------------------------------------------
London Fix          Golden          Silverish       PLATINUM           PALLADIUM
AM       PM                  AM       PM         AM       PM
--------------------------------------------------------------------------------
Oct 23, 2019   1494.25   1494.45   17.5350   895.00   896.00   1753.00   1753.00
October 22, 2019   1487.45   1485.35   17.6250   888.00   887.00   1756.00   1754.00
--------------------------------------------------------------------------------
New York Spot Toll
Market place IS OPEN (Volition close in two hrs. 33 mins.)
----------------------------------------------------------------------
Metals          Bid        Ask           Alter        Low       High
----------------------------------------------------------------------
Gold         1503.threescore     1504.lx     11.60  +0.78%    1491.lxx  1504.sixty
Silver       17.eighty         17.ninety     0.28  +one.57%       17.45    17.92
Platinum     922.00       927.00    seven.00  +0.77%       917.00   935.00
Palladium    1760.00       1785.00     35.00  +two.03%   1717.00   1791.00
----------------------------------------------------------------------
Last Update on 10/24/2019 fourteen:27
----------------------------------------------------------------------
Asia / Europe Spot Cost
MARKET IS Open up (Will close in 2 hrs. 33 mins.)
----------------------------------------------------------------------
Metals          Bid        Ask           Change        Depression       High
----------------------------------------------------------------------
Aureate         1503.sixty     1504.60     xi.60  +0.78%    1487.50  1504.lx
Silver       17.80         17.90     0.28  +1.57%       17.35    17.92
Platinum     922.00       927.00    7.00  +0.77%       916.00   935.00
Palladium    1760.00       1785.00     35.00  +2.03%   1699.00   1791.00
----------------------------------------------------------------------
Terminal Update on 10/24/2019 14:27
----------------------------------------------------------------------
File created at 14:28:08 on Thu October 24 2019

                Well-nigh The states

                Website Terms of Use

                Privacy Policy

                Advertise With U.s.

                Careers

                Contact U.s.

                Feedback

Tibor Kovacs, Hungary; LO6.one.6, vi.iv.seven /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.iii.0-7.1.1;AOO4.i.9
Please, edit the initial postal service in the topic: add the word [Solved] at the starting time of the subject line - if your problem has been solved.

User avatar
Zizi64
Volunteer
Posts: 10300
Joined: Wed May 26, 2010 seven:55 am
Location: Budapest, Republic of hungary

Re: Problem retreving information from external link

Postby Zizi64 » Thu October 24, 2019 eight:55 pm

https://www.kitco.com/market/

This page does not containing whatever HTML table. It is a dynamic spider web folio...

Merely the page on this link

https://www.kitco.com/

containing some available html data tables:

Tibor Kovacs, Republic of hungary; LO6.1.6, half-dozen.iv.7 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.iii.0-7.1.1;AOO4.ane.ix
Please, edit the initial post in the topic: add the word [Solved] at the start of the subject line - if your problem has been solved.

User avatar
Zizi64
Volunteer
Posts: 10300
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Republic of hungary

Re: Problem retreving data from external link

Postby Vancejo » Thu Oct 24, 2019 ix:14 pm

That returns a "The link could not exist updated." in the first row on my organization.

Windows x Open Office 4.1.7

Vancejo
Posts: 6
Joined: Thu Oct 24, 2019 vii:13 pm

Re: Trouble retreving information from external link

Postby Villeroy » Thu Oct 24, 2019 9:24 pm

Works fine with LibreOffice Calc.
AOO: Link could not be updated

Please, edit this topic'south initial mail service and add together "[Solved]" to the subject line if your trouble has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice

User avatar
Villeroy
Volunteer
Posts: 30480
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Problem retreving information from external link

Postby Zizi64 » Thu Oct 24, 2019 9:29 pm

My attached file was created in LibreOffice 6.two.eight, and it works for me later on downloading it from the forum.

Tibor Kovacs, Hungary; LO6.1.6, 6.4.7 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.three.0-7.one.1;AOO4.1.9
Please, edit the initial mail in the topic: add the word [Solved] at the beginning of the bailiwick line - if your problem has been solved.

User avatar
Zizi64
Volunteer
Posts: 10300
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Republic of hungary

Re: Problem retreving data from external link

Postby Vancejo » Thu Oct 24, 2019 10:08 pm

I uninstalled AOO and installed LibreOffice and it works like a gnaw.

Windows ten Open Office 4.1.seven

Vancejo
Posts: 6
Joined: Thu October 24, 2019 7:xiii pm

Re: Problem retreving data from external link

Postby Vancejo » Thu October 24, 2019 x:21 pm

Many many thanks for your help! Should I mark this solved, fifty-fifty though the problem remains in AOO?

Windows 10 Open Office iv.1.7

Vancejo
Posts: six
Joined: Thu October 24, 2019 7:xiii pm

Re: [Solved] Trouble retreving data from external link

Postpast Hagar Delest » Fri Oct 25, 2019 12:34 pm

I've done so.
You've found a way to sort the effect, that'due south the central indicate.
I fear that that quality departure between AOO and LO will seal the fate of AOO in the long run.

LibreOffice 7.two.1 on Xubuntu 21.04 and 7.two.1 portable on Windows 10

User avatar
Hagar Delest
Moderator
Posts: 30235
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Return to Calc

Who is online

Users browsing this forum: No registered users and 27 guests

davenportbiles1978.blogspot.com

Source: https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=99775

Post a Comment for "Open Office "Error Reading Data From the Internet.""