|
|
Importing a Calc Sheet into a Writer Table
From NeoWiki
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.
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:
- 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 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 {{menu|Table}] then Convert and Text to table
- In the Convert Text to Table dialog window, choose the deisred options and click on OK
