[SOLVED] Converting a newline separated list into a table

soup · Newbie Joined: 14 Jul 2008 Posts: 2

Hello,

I'm sorry if this is really simple but I've looked through the help and the forums. I'm probably having trouble searching for the answer because I don't really know what to call it.

I have a list. One item per line, in a regular text file. I've decided I want to put this list into one column of a table, one row per item. If I paste the list into one cell of a table, it all get stuffed into that cell. If I have 3 items and I highlight three cells, then I get the three items pasted three times.

My actual list is well over a hundred items, so I don't want to do this manually. I could write a sed/perl script to convert it to an HTML table, then paste that in. Or probably write an ooo macro if I'm willing to learn. But I can't escape this feeling like I'm missing something and there's a much easier way. As a side note, if it's possible/easier in calc but not writer, that works for me just fine Smile

Any help would be greatly appreciated.
Thanks in advance,
Soup

Robert Tucker · Posted: Mon Jul 14, 2008 10:23 am Post subject:

Highlight the list, Table>Covert>Text to Table. Separate text at "Paragraph". OK.
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot)

David

soup · Newbie Joined: 14 Jul 2008 Posts: 2

Awesome!
Thanks a lot to both of you Smile

Soup