Inserting Calc data into Writer

danny_nj · Newbie Joined: 12 May 2011 Posts: 3

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.

jrkrideau

JohnV · Posted: Thu May 12, 2011 4:50 pm Post subject:

If you do copy, Paste Special as Unformatted Text each row will be a paragraph.

danny_nj · Newbie Joined: 12 May 2011 Posts: 3

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.

JohnV · Posted: Sun May 15, 2011 10:45 am Post subject:

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.

danny_nj · Newbie Joined: 12 May 2011 Posts: 3

Thanks, that worked like a charm!

joris77 · Newbie Joined: 24 Apr 2012 Posts: 1

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...