Copy calc data to writer table

Steve_Edmonds · August 18, 2011, 12:25am

Hi.
I am just copying some data from a calc sheet into a table in writer without wanting to embed it as a calc8 item.
I find if I copy from a column of data from calc, paste special temporarily somewhere (outside a table) in writer as html (I get a table of data) then copy the html table and paste into the writer table my data is transfered. I can't copy from calc and paste or paste special into the writer table.
This is evident in 3.4.1 mac, 3.3.2 Linux and OOO3.2.1 Linux.

Is this logical or am I missing something, would a feature request to add another paste special item "Paste to table" be useful or a more sensible approach (i.e. on paste special>unformatted text to have a prompt "Paste to separate rows" if pasting into a table.
steve

soumalya_ray · August 18, 2011, 2:20pm

i am searching for this too.i did not even know about the "paste special"
approach.thanks for sharing this.
lets hope for a better alternative though.
regards

Tom_Davies · August 18, 2011, 2:37pm

Hi
I would cheat by pasting into a text-edior such as Notepad, Gedit or Kate or
something. Then copy&paste from there into Writer.
Regards from
Tom

cornouws · August 18, 2011, 6:06pm

Hi Steve,

Steve Edmonds wrote (18-08-11 02:24)

I am just copying some data from a calc sheet into a table in writer
without wanting to embed it as a calc8 item.
I find if I copy from a column of data from calc, paste special
temporarily somewhere (outside a table) in writer as html (I get a table
of data) then copy the html table and paste into the writer table my
data is transfered. I can't copy from calc and paste or paste special
into the writer table.
This is evident in 3.4.1 mac, 3.3.2 Linux and OOO3.2.1 Linux.

Is this logical or am I missing something,
[..]

Have you tried paste as RTF?
That always works for me (also 3.3.2 / 4.3.2 on Linux).

Regards,

Steve_Edmonds · August 18, 2011, 6:37pm

Paste as RTF pastes all the rows of data from calc into one cell of the table, but with font formatting, not row for row.
Do you get a row for row paste?
steve

ponsiarceds · August 18, 2011, 6:44pm

Steve Edmonds wrote:

Hi.
I am just copying some data from a calc sheet into a table in writer
without wanting to embed it as a calc8 item.
<snip>
Is this logical or am I missing something, would a feature request to
add another paste special item "Paste to table" be useful or a more
sensible approach (i.e. on paste special>unformatted text to have a
prompt "Paste to separate rows" if pasting into a table.
steve

I use the PasteAsValue extension:
http://extensions.services.openoffice.org/en/project/pasteasvalue
The only drawback being that the top row of the table is automatically
bolded & centred.
It installs a button ( a Capital 'T' ) in the toolbar.

cornouws · August 18, 2011, 7:13pm

Steve Edmonds wrote (18-08-11 20:37)

Have you tried paste as RTF?
That always works for me (also 3.3.2 / 4.3.2 on Linux).

Paste as RTF pastes all the rows of data from calc into one cell of the
table, but with font formatting, not row for row.
Do you get a row for row paste?

Sorry, my bad. Had overseen that you pasted in a table.

I remember indeed this being an old issue.
Not so long ago, one of the great devs of OpenOffice.org did make a start with (take a look at) it.
Could find that issue #, good as reference prolly.

cornouws · August 18, 2011, 7:53pm

Cor Nouws wrote (18-08-11 21:12)

I remember indeed this being an old issue.
Not so long ago, one of the great devs of OpenOffice.org did make a
start with (take a look at) it.
Could find that issue #, good as reference prolly.

http://openoffice.org/bugzilla/show_bug.cgi?id=24500

cornouws · August 18, 2011, 8:06pm

Cor Nouws wrote (18-08-11 21:52)

Cor Nouws wrote (18-08-11 21:12)

I remember indeed this being an old issue.
Not so long ago, one of the great devs of OpenOffice.org did make a
start with (take a look at) it.
Could find that issue #, good as reference prolly.

http://openoffice.org/bugzilla/show_bug.cgi?id=24500

And here is 'our' issue:
Bug 37223 - TABLES: Cannot paste from Calc into a Writer table
https://bugs.freedesktop.org/show_bug.cgi?id=37223

Tom_Davies · August 20, 2011, 10:39am

________________________________
From: Cor Nouws <oolst@nouenoff.nl>
To: users@global.libreoffice.org
Sent: Thu, 18 August, 2011 21:05:59
Subject: Re: [libreoffice-users] Copy calc data to writer table

Cor Nouws wrote (18-08-11 21:52)

Cor Nouws wrote (18-08-11 21:12)

I remember indeed this being an old issue.
Not so long ago, one of the great devs of OpenOffice.org did make a
start with (take a look at) it.
Could find that issue #, good as reference prolly.

http://openoffice.org/bugzilla/show_bug.cgi?id=24500

And here is 'our' issue:
Bug 37223 - TABLES: Cannot paste from Calc into a Writer table
https://bugs.freedesktop.org/show_bug.cgi?id=37223

Cor
http://nl.libreoffice.org

Hi
Does there need to be a link from the OOo one to the LO one or has it been fixed
in OOo? I noticed the link from the LO one to the OO one so i just wondered if
a link the other way might be useful too and then i got a bit confused about the
end of the OOo thread.
Regards from
Tom

Villeroy · August 20, 2011, 3:57pm

Like so often, the simple solution involves the Base component.

Database...[X] Connect to existing db

Type: <Spreadsheet>Specify your spreadsheet document and if it requires a
password or not
[X] Register dbSave the so called "database document". So far it is a mere
configuration file. Your editable data remain in the spreadsheet file.
The "database tables" reflect the used data ranges of the sheets or the
defined database ranges (Calc:Data>Define...).
In any Writer document (or even Calc) you can hit F4 and drag the
spreadsheet table from the left pane of the data source window into your
document. The import dialog provides some formatting options for the
resulting table and which columns should be included.
Simple queries added to the database configuration let you recombine any
collection of rows and columns in any order of rows and columns. Queries are
virtual tables and can be used just like the original sheet tables (used
ranges of sheets and data ranges).

Villeroy · August 20, 2011, 10:24am

Like so often, the simple solution involves the Base component.

Database...

[X] Connect to existing db
Type: <Spreadsheet>
Specify your spreadsheet document and if it requires a password
[X] Register db
Save the so called "database document". So far it is a mere configuration
file. Your editable data remain in the spreadsheet file. The "database
tables" reflect the used data ranges of the sheets or the defined database
ranges (Calc:Data>Define...). You can hide some of the pseudo-tables if they
do not contain adequate data structures.

In any Writer document (or even Calc) you can hit F4 and drag the
spreadsheet table from the left pane of the data source window into your
document.
The import dialog provides some formatting options for the resulting table
and which columns should be included.
Simple queries added to the database configuration let you recombine any
collection of rows and columns in any order of rows and columns. Queries are
virtual tables and can be used just like the original sheet tables (used
ranges of sheets and data ranges).