Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

3 Answers 3

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: http://www.oooforum.org/forum/viewtopic.phtml?t=44629

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
1  
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

 
discard

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.