Home » Questions » Computers [ Ask a new question ]

Copying a region of Calc cells into a Writer document as a table

Copying a region of Calc cells into a Writer document as a table

"I need to take a region of spreadsheet cells and paste them into a Writer document as a table.
How do I do this?"

Asked by: Guest | Views: 267
Total answers/comments: 2
Guest [Entry]

"Select and copy the cells from Calc.

In Writer:

Edit > Paste Special

The Paste Special dialog will appear.

Select HTML (HyperText Markup Language) and click OK.

Your copied cells will now be pasted into the document as an HTML table.

For all intents and purposes this is now a table in Writer and not the embedded object you would have seen from a simple copy-paste."
Guest [Entry]

"To elaborate on @8Days' answer:

You must Paste Special into the top-level of the document. It does not work properly if you are creating a table inside a table cell (Writer gets confused), and you have to first paste special into the top-level of the document, then you can cut+paste into a table inside a table cell."