I have a simple spreadsheet in Calc that has 6 columns and twenty rows with some text in it. I would like to import the contents of this sheet into a table in a writer document. How do I this? Whenever I copy and paste I only get the complete spreadsheet over instead of just the cell data. TIA!

Copy the cell range in Calc.Writer-menu:Edit>Paste Special... [Ctrl+Shif+V].This pops up a dialog with several options. You get the same options from the clipboard-icon on the main toolbar.calc8 = insert editable object, the default you already knowDDE link = insert a table linked to the Calc tableHTML and RTF = insert as formatted tableGDI and Bitmap = insert as pictureUnformatted text, inserted with tabs between columns, can be converted to a table [menu:Table>Convert>Text to table]

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x

Using the HTML and RTF formatting gets you most of the way there, but there are some formatting hold-overs that you may want to clean up. Here is a process to get the formatted Calc information into a Writer table:

Create a new Writer Table with the number of columns and rows you need (Table->Insert->Table, or Ctrl+F12)

In Calc, select and copy the range of cells you want to import into Writer

In Writer, use Paste Special (Edit->Paste Special... or Ctrl+Shift+V) below or above the Writer table (not in the table, yet). For 'Selection', choose either "Formatted text [RTF]" or "HTML (HyperText Markup Language)". This creates a temporary table.

Select and copy the contents of the newly created (but badly formatted) temporary table (you may have to scroll back to where you were -- Writer has a glitch that scrolls up sometimes after the previous step) (also, there probably aren't borders on this table, and the paragraph spacing might be funny).

Paste the contents of the temporary table into the original table you created in the first step.

Delete the temporary table.

The temporary table is necessary to bridge the gap between Writer's handling of external formatted data and Writer's handling of internal tables. Hopefully this will get cleaned-up in a future release.