https://bugs.freedesktop.org/show_bug.cgi?id=65537
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #9 from [email protected] --- Hallo Thomas, I´m glad to get a new reply. After about a week I didn´t look every day - sorry. I added also the Example-Source Html-File as attachment. Step by Step: Create the Example HTML-File with the Sample-Code from Description or take the new Attachment with the Html-File “LibreOfficeCalcErrorExtLinkHtmlNamedTable.html”. Linking to external Data (Source: “0310CG3-LinkingCalcData.odt” on Page 13) You can do this in two ways: using the External Data dialog or using the Navigator Using the External Data dialog 1) Open the Calc document where the external data is to be inserted. This is the target document. 2) Select the cell where the upper left-hand cell of the external data is to be inserted. 3) Choose Insert → Link to External Data. 4) On the External Data dialog, type the URL of the source document (LibreOfficeCalcErrorExtLinkHtmlNamedTable.html) or click the [...] button to open a file selection dialog. Press Enter to get Calc to load the list of available tables. If a dialog “Importsettings” occurs, then chose “automatic” 5) In the Available tables/range list, select the named table “HTML__MyTableName” to insert. 6) Click OK to close the dialog and insert the linked data. If you inserted the „HTML__MyTableName“ then Calc show the ErrorMessage in the target cell. If you inserted the „HTML_1“ (this is an automatic given name) then Calc the correct Html-Table. Using the Navigator 1) Open the Calc spreadsheet in which the external data is to be inserted (target document). 2) Open the document from which the external data is to be taken (source document). If the source document is a Web page, choose Web Page Query (LibreOffice Calc) as the file type. 3) In the target document, press F5 to open the Navigator. 4) At the bottom of the Navigator, select the source document. The Navigator now shows the range names or the tables contained in the source document. Click on the + next to Range names to display the list. 5) In the Navigator, select the Insert as Link drag mode 6) Select the required range or table and drag it from the Navigator into the target document, to the cell where you want the upper left-hand cell of the data range to be. 7) In the target document, check the Navigator. Instead of a + by Range names, it shows a + by Linked areas. Click the + to see the same range name If you inserted the „HTML__MyTableName“ then Calc show the ErrorMessage in the target cell. If you inserted the „HTML_1“ (this is an automatic given name) then Calc the correct Html-Table. If there are any further question, please don´t hesitate. Bye. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
