In LibreOffice Calc, I want to use the Inserting External Data in Table (WebQuery) feature and pass variables as arguments in the URL.
These variables should take the value of certain cells in the Calc spreadsheet. In other words, I want to use data from a cell as a parameter value in a webquery.
This works as expected with Excel, which prompts me a window to give a value to each of my variables. In hard coded value, or by a cell address.
LibreOffice Calc, on the other hand, doesn’t prompt me for anything and displays the spreadsheet directly, with only the column headers.
In Calc, how can I get a webquery to work with variable arguments passed in the URL please ?