Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 2 down vote accepted

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.

share|improve this answer
This has been tested of a slight elaboration of the asker's own comment. – random Nov 4 '09 at 6:23

A quick Google search brings up this thread:

You can already paste as a new table, apparently. But to paste into an existing table, you need to first paste into a new document, then copy that and then paste it into the original table using the "Paste Special > HTML" command.

share|improve this answer
No. I appreciate the search help + the links to forums, that's helpful. But if you state something as fact please try it yourself first. When you paste a Calc cell region directly into a Writer document, you get this weird embedded object that looks awful + is different from a Writer table. – Jason S Nov 4 '09 at 4:54
OK, here's what seems to work. You "Paste Special" as HTML directly as a new table in an empty Writer document. That yields a table. Then you can cut+paste cells normally in Writer. – Jason S Nov 4 '09 at 4:55

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.