I’m trying to link exchange rates from this page XML Daily Foreign Exchange Rates for U.K. Pound Sterling (GBP) to a spreadsheet. I use it at work in Excel and it works fine. But it does not work in Libreoffice Calc for some reason. I tried to Sheet/Link to External Data but it does not insert a table. I also noticed Data/XMLSource but it’s greyed out. I woonder if it’s possible to do in Libreoffice at all.
I think it’s possible with WEBSERVICE() and FILTERXML() functions working together.
Sample file to recover the data from mentioned web.
Thanks for the example. I tried to follow your example but only able to get 1 cell works. Can you show me how to “extend” the range?
I think the answer is here:
In short: use array function.