Is it possible to use a dynamic URL when creating a link to external data in libreoffice calc? I am currently trying to make a spreadsheet that will query a web page for tables, but I want the URL that the tables are generated from to be dynamic - based off what is entered into a specific cell. I have tried to reference a cell for the URL when using the ‘link to external data’ but it does not seem to work. Is there some other way to do this so that when I enter something into a cell it will automatically update the queried tables with the new URL?
I think what you are looking for are the WEBSERVICE() and FILTERXML() functions,
The help:
WEBSERVICE plus FILTERXML help
but there is a bug: fdo# 88257 XMLpath in FIlterxml does not work with arrayfunction