|
|
User:Jgd/Translations
From NeoWiki
(Difference between revisions)
| Revision as of 15:27, 10 March 2007 (edit) Jgd (Talk | contribs) (→Saving without synchronization - typos) ← Previous diff |
Revision as of 15:30, 10 March 2007 (edit) (undo) Jgd (Talk | contribs) m (→Saving with synchronization - typos) Next diff → |
||
| Line 18: | Line 18: | ||
| ===Saving with synchronization=== | ===Saving with synchronization=== | ||
| - | The web page must be publicly | + | The web page must be publicly accessible.<br/> |
| If you want your table being synchronized with the web page, you can proceed in the following way: | If you want your table being synchronized with the web page, you can proceed in the following way: | ||
| * Open the web page which contains the table you want to import. | * Open the web page which contains the table you want to import. | ||
| Line 26: | Line 26: | ||
| * Press {{key|Enter}} or {{key|Return}}. | * Press {{key|Enter}} or {{key|Return}}. | ||
| * In the dialog that appears you'll see in the {{section|Available tables/ranges}} section among several options {{prefName|HTML_tables}} and {{prefName|HTML_all}}. | * In the dialog that appears you'll see in the {{section|Available tables/ranges}} section among several options {{prefName|HTML_tables}} and {{prefName|HTML_all}}. | ||
| - | * Select the table you want to insert and click {{key|OK}}. If you are not able to find it, select {{prefName|HTML_all}}. Later you will be able to copy/paste the | + | * Select the table you want to insert and click {{key|OK}}. If you are not able to find it, select {{prefName|HTML_all}}. Later you will be able to copy/paste the part being of interest to you. |
| - | * You may specify a synchronization rate by checking the {{prefName|Update every}} checkbox | + | * You may specify a synchronization rate by checking the {{prefName|Update every}} checkbox and setting the synchronizations rate in the provided box. |
| [[Category:Tips and Hints]][[Category:NeoOffice]] | [[Category:Tips and Hints]][[Category:NeoOffice]] | ||
Revision as of 15:30, 10 March 2007
Getting data from HTML in Calc
The Calc module of NeoOffice allows you to save tables from HTML pages. Several methods are available. One of them allows you to synchronize your tables with those of the internet site.
Saving without synchronization
With almost all navigators, you can select the table on the web page, then simply copy/paste it in a spreadsheet.
Sometimes all the table is pasted in only one column. Then you can use one of the following methods:
First method :
- Copy the table Cmd-C.
- Open a Calc document and in the Edit menu, choose the Paste Special… and one or the other option can give the desired result.
Second method, usable if the page is publicly accessible:
- Open a Writer Web document. To do that :
- Go in the File menu, choose the New sub-menu and the HTML Document item.
- Copy the URL of the web page which contains the desired table then paste it in the Load URL field located on the top and on the left side of the document toolbar.
- Press Enter or Return.
- Select the table you want to insert in a spreadsheet, copy it Cmd-C.
- Paste it Cmd-V in your Calc document.
Saving with synchronization
The web page must be publicly accessible.
If you want your table being synchronized with the web page, you can proceed in the following way:
- Open the web page which contains the table you want to import.
- Copy the URL.
- Open a Calc document then select a cell.
- Choose the Link to External Data… sub-menu of the Insert menu.
- Press Enter or Return.
- In the dialog that appears you'll see in the Available tables/ranges section among several options HTML_tables and HTML_all.
- Select the table you want to insert and click OK. If you are not able to find it, select HTML_all. Later you will be able to copy/paste the part being of interest to you.
- You may specify a synchronization rate by checking the Update every checkbox and setting the synchronizations rate in the provided box.
