To elaborate on Villeroy's Post:
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.