LibreOffice 7.5 Help
For example, if you found an Internet page containing current stock exchange information in spreadsheet cells, you can load this page in LibreOffice Calc by using the following procedure:
In a LibreOffice Calc document, position the cursor in the cell into which you want to insert the external data.
Enter the URL of the document or Web page in the dialogue. The URL must be in the format: http://www.my-bank.com/table.html. The URL for local or local area network files is the path seen in thedialogue.
LibreOffice loads the Web page or file in the "background", that is, without displaying it. In the large list box of thedialogue, you can see the name of all the sheets or named ranges you can choose from.
Select one or more sheets or named ranges. You can also activate the automatic update function every "n" seconds and click.
The contents will be inserted as a link in the LibreOffice Calc document.
Save your spreadsheet. When you open it again later, LibreOffice Calc will update the linked cells following an enquiry.
Under LibreOffice - PreferencesTools - Options - you can choose to have the update, when opened, automatically carried out either always, upon request or never. The update can be started manually in the dialogue under .