Ask Your Question
0

Create a Contact Phone Number List and Sort by Name

asked 2018-04-05 16:59:20 +0100

bds1959 gravatar image

updated 2018-04-05 17:00:07 +0100

Hello - I'd like to create a contact phone number list using LibreOffice, and sort it by name.

I've attached a sample of a Calc spreadsheet. Rows 2-thru-30 would be the "Raw data;" it's simply a list of contacts and numbers in random order.

Rows 34-thru-48 show what I'd like the output to look like - two name/phone number columns per page.

There could potentially be several hundred name/phone numbers, so, obviously, a print-out would require multiple sheets of paper. I need the names to continue through all of the sheets in alphabetical order.

Is it possible to do this with a LibreOffice program? I was assuming CALC? OR, could it be done in BASE?

The other question is regarding on-going... when names are added, I'd like to be able to just put them at the beginning (or, I suppose, at the END if it would be a BASE document?) then simply re-sort, and, when the output is printed, all the names will still be in alphabetical order.

Any help/guidance/assistance would be greatly appreciated.

Thanks! C:\fakepath\Test-Sort-Calc.ods

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-04-05 17:02:20 +0100

You could copy+paste the single sorted column to Writer (as RTF/HTML, to get proper Writer table), and use two-column page layout in Writer.

edit flag offensive delete link more

Comments

Thanks, Mike! What you're suggesting makes sense! MAYBE I'm over-thinking, which I have a tendency to do, but I was thinking that any updates could be done on a spreadsheet, then [re-]sort it, then [re-]copy-paste it to the Writer. However... When I do a copy-paste from the CALC spreadsheet to the Writer document, it copies the whole group of cells as an image rather than just copying the raw data. Am I missing something?

bds1959 gravatar imagebds1959 ( 2018-04-05 19:07:32 +0100 )edit

First: Writer also allows to sort tables. Use Tools->Sort.

As to pasted image - I have mentioned that you need to paste as - using the drop-down of the Paste button, or using Paste Special.

Mike Kaganski gravatar imageMike Kaganski ( 2018-04-05 19:15:28 +0100 )edit

Mike - I did find the Paste-Special, unformatted, however, then the spacing is off. And also I found the two columns, but I'm having a mental block on having essentially two columns of two columns! How/where do I get to the second 2-column column? It's there, but does it start filling when the first column is filled-up? THANKS!

bds1959 gravatar imagebds1959 ( 2018-04-05 19:29:18 +0100 )edit

Hmm... where did I mention "unformatted"?

as RTF/HTML

As to your "2-column column" - I'm not sure what you mean. Revising my answer, I find that I said "paste single column", when I wanted to mean "2-column table (name, phone) in one column on paper" - hope you see what I mean.

Mike Kaganski gravatar imageMike Kaganski ( 2018-04-05 19:51:09 +0100 )edit
1

Here is a screen-cast with two variants of creating two-column layout: using sections, and using page style. Sections allow for more flexible layout (like distributing content, as shown).

Mike Kaganski gravatar imageMike Kaganski ( 2018-04-05 20:03:47 +0100 )edit

THANKS! I'll look closer - don't have much time right now, but it looks like this will help! Thanks again!

bds1959 gravatar imagebds1959 ( 2018-04-05 20:37:57 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-04-05 16:59:20 +0100

Seen: 80 times

Last updated: Apr 05 '18