[Solved] From Calc to table in Writer?

[nfoldager]

I just want to copy a cell range in a spreadsheet (Calc) and insert it as a table in a text document (Writer).
I would expect, that I could just highlight the celle range in Calc and draw it into the text document, and there it would automatically be a table. However, it is not that easy, and I cannot find the way to do it.

I appreciate any help.

Best regards,
Niels

[robleyd]

Have you tried copying the range and using paste special to insert as a table in Writer?

Select the range you want and copy it - Ctrl+C or right click and select Copy
Go to the desired location in your Writer document and select Edit | Paste Special (or use Ctrl+Shift+V); from the dialog that opens, choose Formatted Text (RTF).

[nfoldager]

> Have you tried copying the range and using paste special to insert as a table in Writer?

Yes, but I did not select "Formatted text (RTF)" (not obvious for me). That is the solution.

Thank you!

Best regards,
Niels