OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Inserting Calc data into Writer

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer
View previous topic :: View next topic  
Author Message
danny_nj
Newbie
Newbie


Joined: 12 May 2011
Posts: 3

PostPosted: Thu May 12, 2011 7:12 am    Post subject: Inserting Calc data into Writer Reply with quote

Hi

I have a spreadsheet that I would like to format into a Writer document. For instance, I would like to transform each Row into a paragraph such that the the Row 1's Column 1 data is bold, linebreak, Row's Column 2 data is underline, linebreak etc. and the next paragraph would have the same formatting for Row 2's data and so on.

This is such a straightforward task, I just can seem to figure it out! Thanks for any help.
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Thu May 12, 2011 10:04 am    Post subject: Re: Inserting Calc data into Writer Reply with quote

danny_nj wrote:
Hi

I have a spreadsheet that I would like to format into a Writer document. For instance, I would like to transform each Row into a paragraph such that the the Row 1's Column 1 data is bold, linebreak, Row's Column 2 data is underline, linebreak etc. and the next paragraph would have the same formatting for Row 2's data and so on.

This is such a straightforward task, I just can seem to figure it out! Thanks for any help.


If I understand you correctly it does not seem at all straight forward to me. Why not just paste in the speadsheet as a table and format that? Do a paste special and paste as HTML.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Thu May 12, 2011 4:50 pm    Post subject: Reply with quote

If you do copy, Paste Special as Unformatted Text each row will be a paragraph.
Back to top
View user's profile Send private message
danny_nj
Newbie
Newbie


Joined: 12 May 2011
Posts: 3

PostPosted: Sat May 14, 2011 11:42 pm    Post subject: Re: Inserting Calc data into Writer Reply with quote

Thanks for the very quick responses. I tried out your suggestions and these were my results.

Here's the example spreadsheet:




Here's the result from pasting it as HTML:




Here's the result from pasting it as Unformatted Text:




Here's how I would like to have it formatted:




Is there a way to do various formatting manipulations automatically like I did in the previous screenshot? It's easy to do it manually obviously if there are three rows, but
it's a lot more difficult if there are three hundred!

Thank you.
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Sun May 15, 2011 10:45 am    Post subject: Reply with quote

You don't want to copy and paste. You want to do a merge with your Calc file as the data source.

Register the file as a data source. File > New > Database, bullet Connect to Existing..., select Spreadsheet below and complete the wizard.

Open a new Writer document, press F4, open your database, open the Tables item and click your table. Click the box at the upper left of your records so all records are selected. Click the Data to Text icon and put the bullet in Fields. In the right side box type Name colon space. Select the name field and click the arrow. Click after the name field and press Enter. Repeat for Age and Occupation. Make sure you have at least one blank line at the bottom to separate your records. Click OK and you're done.
Back to top
View user's profile Send private message
danny_nj
Newbie
Newbie


Joined: 12 May 2011
Posts: 3

PostPosted: Wed May 18, 2011 2:01 am    Post subject: Re: Inserting Calc data into Writer Reply with quote

Thanks, that worked like a charm!
Back to top
View user's profile Send private message
joris77
Newbie
Newbie


Joined: 24 Apr 2012
Posts: 1

PostPosted: Tue Apr 24, 2012 8:22 am    Post subject: Reply with quote

Great tip! Thanks JohnV

Does somebody know if it is possible to make some of the text bold when I use the data to text feature. Would save a lot of work...
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group