Import Calc spreadsheet content into Writer table?

Discuss the word processor

Import Calc spreadsheet content into Writer table?

Postby Moon » Mon Sep 22, 2008 2:05 pm

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!
OOo 3.1.1 on Ms Windows XP SP3
Moon
 
Posts: 16
Joined: Mon Sep 22, 2008 2:00 pm

Re: Import Calc spreadsheet content into Writer table?

Postby Villeroy » Mon Sep 22, 2008 2:47 pm

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 know
DDE link = insert a table linked to the Calc table
HTML and RTF = insert as formatted table
GDI and Bitmap = insert as picture
Unformatted 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 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17278
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Import Calc spreadsheet content into Writer table?

Postby mattball » Tue Nov 18, 2008 12:08 am

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.
OOo 3.0.X on Ms Windows XP + Mac OSx Leopard
mattball
 
Posts: 1
Joined: Mon Nov 17, 2008 11:48 pm

Re: Import Calc spreadsheet content into Writer table?

Postby heisenberg2o » Wed Nov 19, 2008 4:07 pm

Many thanks to Mattball who gave a clear recipe for this annoying limitation.
OOo 3.0.X on Debian + Mac OSx Tiger
heisenberg2o
 
Posts: 1
Joined: Wed Nov 19, 2008 3:59 pm

Re: Import Calc spreadsheet content into Writer table?

Postby olof nord » Mon Apr 25, 2011 5:21 pm

How come this issue is not solved yet?
The integration between this two programs should IMHO work better.
LibreOffice 3.3.2 on Ubuntu 10.10
olof nord
 
Posts: 1
Joined: Mon Apr 25, 2011 5:18 pm

Re: Import Calc spreadsheet content into Writer table?

Postby Hagar Delest » Mon Apr 25, 2011 10:27 pm

You should report it (haven't seen any feature request after a quick search): [Tutorial] Reporting bugs or suggestions.
AOO 4.0.1 on Windows 7 and Xubuntu 13.10 (Saucy Salamander)
User avatar
Hagar Delest
Moderator
 
Posts: 25088
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Import Calc spreadsheet content into Writer table?

Postby Villeroy » Tue Apr 26, 2011 12:11 am

File>New>Database...
[X] Connect to existing database
Database type: Spreadsheet
Specify your spreadsheet document
[X] Register the new database
Save the database and forget the database.

In Writer or Calc hit F4 and drag the table into your document. Drag the icon on the left side or a selection of rows from the right side.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17278
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Writer

Who is online

Users browsing this forum: No registered users and 18 guests