Importing a Calc Sheet into a Writer Table

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
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 into a Writer table, you have two options:+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]] menu and then {{menu|Copy]] or by pressing {{key|Cmd-C}}+*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}] then {{menu|Convert}} and {{menu|Text to 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 deisred options and click on {{button|OK}}+**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



This article in other languages: Français Italiano
Personal tools