Book Print out

[lostsoul]

Ok I am back again trying to get a print out of my 300 books; over the past months since I first posted this question; I tried the following formats - Azw3 then Bib then CVS the E pub then lastly Mobi and so far can t see a dang thing happening.

All I get is weird numbers and letters and half pages and no book list in sight hoping their are clearer directions then what I got awhile back : )

[speakingtohe]

Are you trying to print the books or a catalogue?

Helen

[lostsoul]

Ok been fooling around some more and finally got CVS to list the books in Libre Office cal but don t see a way to get the authors; they are in column one; and book titles in column two into alphabetical order what do I keep missing ? : )

Just trying to get a print out of the authors and books I have not easy .

[lostsoul]

and then of course the last step how do I get both listings printed up on the same page hum wonder if google has an answer .

[lostsoul]

hum maybe do it the hard way with my bad luck theirs no easy ; maybe assuming I get both listings in order; then print and scan then copy and paste the titles next to the authors; I hope they stay in order during this-drawn out process might that work ?

[speakingtohe]

If you are using a spreadsheet
In Excel you click the left corner square to select the whole sheet
then sort (custom sort if you want multiple levels)
I sort by
author first level
series
series index

The easiest way to print more columns on same page is to cut and paste the columns after it is all sorted.

Sorry I don't use Libre Office but I imagine it is much the same.

Helen

[lostsoul]

Ok yuk this won t be easy never cut then pasted a spread sheet and so far can t find the command to get the letters bigger after I high lite them.

Any body out their use libre cal ?

[lostsoul]

Ops one more thing assuming I can pull it all together guessing their will be no spacing between the lines; so how do I add 1 space between each line hum ? : )

[speakingtohe]

Originally Posted by lostsoul

Ops one more thing assuming I can pull it all together guessing their will be no spacing between the lines; so how do I add 1 space between each line hum ? : )

usually there is reasonable spacing, but you can select the whole sheet and format the row spacing as you wish.

Helen

[lostsoul]

Ok progress using cvs I got the book list into notepad so now wondering how how I get that cvs / notepad list into libre office and lastly how do I get that list even neater looking by adding a space; which has 300 books ; between each line I don t see how that is done yet ?

Thanks for all the help so far I love it and so need it . .

[speakingtohe]

I think you need to import the CSV into the calc part of libre office. (spreadsheet)
https://help.libreoffice.org/Calc/Im...ting_CSV_Files

Then Format your rows which so you have spacing etc.
http://www.techrepublic.com/blog/tr-...reoffice-calc/

Then you want to sort.
https://help.libreoffice.org/Calc/Sort_Criteria

Best to save before sorting as it can take a couple of tries if you are new to spreadsheets

Helen

[theducks]

Originally Posted by speakingtohe

I think you need to import the CSV into the calc part of libre office. (spreadsheet)
https://help.libreoffice.org/Calc/Im...ting_CSV_Files

Then Format your rows which so you have spacing etc.
http://www.techrepublic.com/blog/tr-...reoffice-calc/

Then you want to sort.
https://help.libreoffice.org/Calc/Sort_Criteria

Best to save before sorting as it can take a couple of tries if you are new to spreadsheets

Helen

+1
OO/LO calc , just import

There was a time where CSV was king of the cross application world (Dbase (dbf) was #2 )

[lostsoul]

Ok the cvs file is now in libre cal and now opens up in notepad; if I understand your saying save as text file then open as a text file in libre writer which is their office and it should be their unless I have missed something ?

And your so right it does take a number of trys to get it to open; its very very messy what pops up; I have had pages missing and a combo of weird numbers and letters and lastly paragraphs missing over the past 2/3 days trying to get it right.

But the whole messy process does work its way out after several try's and I don t give up .

[lostsoul]

aww ok have to add spacing will try that; this won t be fun; thanks for the help .

[speakingtohe]

Originally Posted by lostsoul

Ok the cvs file is now in libre cal and now opens up in notepad; if I understand your saying save as text file then open as a text file in libre writer which is their office and it should be their unless I have missed something ?

And your so right it does take a number of trys to get it to open; its very very messy what pops up; I have had pages missing and a combo of weird numbers and letters and lastly paragraphs missing over the past 2/3 days trying to get it right.

But the whole messy process does work its way out after several try's and I don t give up .

Good for you
You should just leave it in calc and print it from there I think. I have never used calc but should be good.

Notepad has no formatting options at all so anything done to line things up and space things out would be very difficult if impossible. And we want it to look decent after all of your effort don't we

1. import CSV
2. Format cells by row and by column.
3. Sort data
4. Cut and paste your data so you have 2 rows of data per page.

2,3, and 4 might take a few tries but once you get it right you will say how nice and remember how to do it. You will probably want to do this again some day.

Helen