|
|
Importing a Calc Sheet into a Writer Table
From NeoWiki
(Difference between revisions)
| Revision as of 03:56, 13 April 2007 (edit) Lorinda (Talk | contribs) ← Previous diff |
Current revision (05:12, 12 January 2008) (edit) (undo) Lorinda (Talk | contribs) (Add process for pasting into an existing table; add link to Solveig Haugland article) |
||
| (One intermediate revision not shown.) | |||
| Line 1: | Line 1: | ||
| - | {{InTranslation}} | ||
| - | |||
| Sometimes you want to import the data from a spreadsheet into a Writer document. If you select the cells to import and do a copy and paste into your document, the table is imported as an OLE object, this is the default option. | Sometimes you want to import the data from a spreadsheet into a Writer document. If you select the cells to import and do a copy and paste into your document, the table is imported as an OLE object, this is the default option. | ||
| - | If you want the data to be imported | + | If you want the data to be imported as a Writer table, you have two options: |
| - | *Select the cells to be imported and copy them by choosing the {{menu|Edit | + | *Select the cells to be imported and copy them by choosing the {{menu|Edit}} menu and then {{menu|Copy}} or by pressing {{key|Cmd-C}} |
| *In the Writer document, under the {{menu|Edit}} menu, choose {{menu|Paste special..}} | *In the Writer document, under the {{menu|Edit}} menu, choose {{menu|Paste special..}} | ||
| Then, either: | Then, either: | ||
| - | *in the {{section|Selection}} section of the dialog window, choose {prefName|Formatted text [RTF]}} and click on {{button|OK}}. The data is imported as a table. | + | *in the {{section|Selection}} section of the dialog window, choose {{prefName|Formatted text [RTF]}} and click on {{button|OK}}. The data is imported as a table. |
| Or: | Or: | ||
| - | *In the {{section|Selection}} section of the dialog window, choose {{prefName|Unformatted text}} and click on {{button|OK}} | + | *In the {{section|Selection}} section of the dialog window, choose {{prefName|Unformatted text...}} and click on {{button|OK}} |
| - | **Select the imported text (separated by tabs), go to the {{menu|Table} | + | **Select the imported text (separated by tabs), go to the {{menu|Table}} then {{menu|Convert}} and {{menu|Text to table}} |
| - | **In the {{window|Convert Text to Table}} dialog window, choose the | + | **In the {{window|Convert Text to Table}} dialog window, choose the desired options and click on {{button|OK}} |
| + | <br> | ||
| + | To paste spreadsheet data into an existing Writer Table, you must create a new table as described above, then copy the contents of the new table and paste into the existing table. | ||
| + | <br><br> | ||
| + | ==Related External Links== | ||
| + | |||
| + | *[http://openoffice.blogs.com/openoffice/2006/06/pasting_openoff.html Pasting OpenOffice Calc Spreadsheets Into Writer, as Tables] by Solveig Haugland | ||
| + | *:In the comments she outlines the steps for pasting Calc data into an existing table. | ||
| <!--Parfois vous désirez importer des données d'une feuille de calcul dans un document Writer. Si vous sélectionnez les cellules à importer et faites un copier/coller dans votre document, le tableau est importé comme objet OLE, c'est l'option par défaut. | <!--Parfois vous désirez importer des données d'une feuille de calcul dans un document Writer. Si vous sélectionnez les cellules à importer et faites un copier/coller dans votre document, le tableau est importé comme objet OLE, c'est l'option par défaut. | ||
Current revision
Sometimes you want to import the data from a spreadsheet into a Writer document. If you select the cells to import and do a copy and paste into your document, the table is imported as an OLE object, this is the default option.
If you want the data to be imported as a Writer table, you have two options:
- Select the cells to be imported and copy them by choosing the Edit menu and then Copy or by pressing Cmd-C
- In the Writer document, under the Edit menu, choose Paste special..
Then, either:
- in the Selection section of the dialog window, choose Formatted text [RTF] and click on OK. The data is imported as a table.
Or:
- In the Selection section of the dialog window, choose Unformatted text... and click on OK
- Select the imported text (separated by tabs), go to the Table then Convert and Text to table
- In the Convert Text to Table dialog window, choose the desired options and click on OK
To paste spreadsheet data into an existing Writer Table, you must create a new table as described above, then copy the contents of the new table and paste into the existing table.
Related External Links
- Pasting OpenOffice Calc Spreadsheets Into Writer, as Tables by Solveig Haugland
- In the comments she outlines the steps for pasting Calc data into an existing table.
