The Navigator now shows the range names and database ranges or the tables contained in the source document.

In the lower combo box of the Navigator select the source document. In the target document open the Navigator. Open two documents: the LibreOffice Calc spreadsheet in which the external data is to be inserted (target document) and the document from which the external data derives (source document). As much formatting as possible is retained, while the filter intentionally does not load any images.

The import filter can create names for cell ranges on the fly. You can also specify that the ranges or tables are updated every n seconds. In the large list box of the dialog, select the named ranges or tables you want to insert. Click the Browse button to open a file selection dialog. This opens the External Data dialog.Įnter the URL of the HTML document or the name of the spreadsheet. Set the cell cursor at the cell where the new content will be inserted.Ĭhoose Sheet - Link to External Data. The following insert methods are available: Inserting by Dialog You can use the same method to insert ranges defined by name from a Calc or Microsoft Excel spreadsheet. With the help of the Web Page Query (LibreOffice Calc) import filter, you can insert tables from HTML documents in a Calc spreadsheet. Inserting External Data in Table (WebQuery)

Excel libreoffice calc