Importing a Calc Sheet into a Writer Table

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 03:34, 13 April 2007 (edit)
Lorinda (Talk | contribs)
(Setting up page for translation)
← Previous diff
Revision as of 03:52, 13 April 2007 (edit) (undo)
Lorinda (Talk | contribs)
(Translation of French page)
Next diff →
Line 1: Line 1:
{{InTranslation}} {{InTranslation}}
 +
 +Some times 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:
 +
 +*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..}}
 +
 +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 into a table.
 +
 +Or:
 +
 +*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}}
 +**In the {{window|Convert Text to Table}} dialog window, choose the deisred options and click on {{button|OK}}
<!--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.

Revision as of 03:52, 13 April 2007

This page is in the process of being translated. In time, the entire article will appear here. Until then, the full article is available in one or more other languages by clicking on the links at the bottom of the page.

Some times 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:

  • Select the cells to be imported and copy them by choosing the {{menu|Edit]] menu and then Formatted text [RTF] and click on OK. The data is imported into 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 {{menu|Table}] then Convert and Text to table
    • In the Convert Text to Table dialog window, choose the deisred options and click on OK



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