Per the instructions on these pages:
I followed the steps exactly for “Inserting by Dialog” and tried every option within:
- Set the cell cursor at the cell where the new content will be inserted.
- Choose Insert - Link to External Data. This opens the External Data dialog.
- Enter the URL of the HTML document or the name of the spreadsheet. Press Enter when finished. Click the … button to open a file selection dialog.
- In the large list box of the dialog, select the named ranges or tables you want to insert.
…and I get most of the data pasted vertically down a column on my spreadsheet.
This might be a simpler approach:
How would you, an experienced Calc user, import charts from the following webpage to a Calc spreadsheet and have the data appear as it does on the webpage?
Thanks in advance