Ask Your Question
0

Calc: Issue with External Data (web)

asked 2018-11-07 21:24:09 +0100

Dmitri gravatar image

Hi all,

I'm having an issue where I insert the following link as external data:

https://www.x-rates.com/table/?from=U...

This is just a live foreign exchange rate table. I go through the steps and select HTML_1.

It loads something like this: https://gyazo.com/7b2a4042616c622be0c...

This is great, it updates the info every 60 seconds and all that.

I close the Calc file and re-open it. It has the (Automatic update of external links has been disabled - Enable Content) at the top. As soon as I enable it, it seems like the previous table isn't overwritten (old data erased and new rates showing) but rather pushed down and the list is now the same 10 currencies twice:

https://gyazo.com/c0199593226bef2cd63...

I'm not sure how to fix this. I need the data to overwrite itself every time. This is messing up formulas that I have on a different sheet.

Thanks in advance.

edit retag flag offensive close merge delete

Comments

I think this is a know bug, but I can't find it now.

m.a.riosv gravatar imagem.a.riosv ( 2018-11-07 23:14:31 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-11-10 21:00:09 +0100

erAck gravatar image

Sounds related to bug tdf#119700

edit flag offensive delete link more

Comments

Thanks for find it.

m.a.riosv gravatar imagem.a.riosv ( 2018-11-11 01:22:42 +0100 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2018-11-07 21:24:09 +0100

Seen: 26 times

Last updated: Nov 10