Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Create a Contact Phone Number List and Sort by Name

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.

ThanksC:\fakepath\Test-Sort-Calc.ods

Create a Contact Phone Number List and Sort by Name

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.

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