Bible verses collected, and sorted by books, chapters and verses, in a Biblical order in LibreOffice calc.

asked 2018-03-15 19:02:12 +0100

This post is a wiki. Anyone with karma >75 is welcome to improve it.

To sort a collection of verses in a Biblical order, I’ve searched often (here and other sites) for such, with no results, and now having built a file that will sort verses in (1 Book, 2 chapter, 3 verses) in proper Biblical order, I thought I would answer it by leaving a copy of one that works, here, for others to use, or improve. It is within this file at http://bit.ly/faithalonereadingplans.

edit retag flag offensive close merge delete

Comments

@Mark McLean: Please do not post as community wiki. See guidelines for asking. Asking and answering your own questions is fine, however.

Jim K ( 2018-03-15 20:39:50 +0100 )edit

@Mark McLean - If you're interested in this sort of thing, you might also like to know about the PHP Scripture Sorting function - it takes an unsorted array like this one and ... sorts it! Works great -- if you use PHP.

David ( 2018-03-15 22:31:57 +0100 )edit

Thanks @David. I did look at them. My buttons were not working, not pointing to macros, there working now. These kind of sites help much. Thanks again, I will spend more time looking at these sites.

Mark McLean ( 2018-03-16 19:49:58 +0100 )edit

add a comment

2 Answers

Sort by » oldest newest most voted

answered 2018-03-16 17:08:50 +0100

Jim K

2716 ●5 ●20 ●42

Macros are best avoided when possible. In this case, a custom sort order can be used. Create a list of three-letter book abbreviations (see https://help.libreoffice.org/Common/S...). The list can be copied from column A of your "Sort Vs help" sheet, but sort by column B first to get the list in order.

Then go to Data -> Sort -> Options -> Custom sort order and select the custom order.

custom sort order

The book, chapter and verse can be split into different columns with spreadsheet functions and then sorted appropriately.

Example file: Sort Verses.ods

To sort, select columns A through D and go to Data -> Sort or click the corresponding toolbar button. Sort by column A with the custom sort order, then by column B and C normally, all ascending.

This may not be as automated as your approach, but it requires no macros, no buttons, and no hidden sheets. It should break less easily because there is less that can go wrong.

edit flag offensive delete link

Comments

Ya! That work good Jim. I will play with it, and I seen a new formula "search", wish I'de of seen that earlier also. Thanks for your time in it.

Mark McLean ( 2018-03-16 17:48:44 +0100 )edit

add a comment

answered 2018-03-15 19:06:27 +0100

Mark McLean

136 ●7 ●12 ●18 http://bit.ly/faithalo...

updated 2018-08-31 02:48:14 +0100

Knowing many others save favorite verses for study and/or for sermons, and having used this file daily for years, LibreOffice 5.3.4.2 and 6.0.0.1, http://bit.ly/dailydesire I believe buttons work now @Jim K. Thanks.

edit flag offensive delete link

Comments

Clicking "Sort" produces "A Scripting Framework error occurred while running the Basic script vnd.sun.star.script:Standard.Module1.Sort_Vs_Sort_?language=Basic&location=application." It should point to a macro located in the document instead of under "My Macros".

Jim K ( 2018-03-15 20:42:11 +0100 )edit

Thanks Jim. I'm really not sure what you mean. I do not know how to have it point to a macro location! I mainly just run macros, call them, I did not trust myself in pulling out the subs for the Sort VS sheet, as I believe you seen!. I just left all my subs in that I use on other sheets! I would like to have it fixed so others could use it. If it's a quick fixes...I would appreciate it???? If I'm not asking to much. Again, thanks for checking it out.

Mark McLean ( 2018-03-15 21:10:03 +0100 )edit

I believe I got it fix Jim. Sure glad ya let me know. Please. test it again. I'm thinking to clean this question up, to delete it and start over? Or is it best to leave it?

Mark McLean ( 2018-03-15 23:47:25 +0100 )edit

OK, the problem is fixed now. Next question, why the calls to .uno:Protect? I had to close out of the dialog when it asked about this. Also, the code could be much improved by using the API rather than recorded dispatcher code. A good place to start is http://www.pitonyak.org/oo.php.

Jim K ( 2018-03-16 16:27:35 +0100 )edit

Ya fixed. Took awhile but now all sums are in the book, and work in another computer without coping subs to My macro's. Thanks. makes it easy to share a file. The "uno"Protect" was made by Record! I like to lock all cell but white ones, where data entered, have. I'll look at your link to see what "dialog" and API is! :~) a lot of this is new to me. I mostly do formula's, record, color! Again Thanks.

Mark McLean ( 2018-03-16 18:00:42 +0100 )edit

add a comment

Bible verses collected, and sorted by books, chapters and verses, in a Biblical order in LibreOffice calc.

Comments

2 Answers

Comments

Comments

Question Tools

Stats

Related questions

Bible verses collected, and sorted by books, chapters and verses, in a Biblical order in LibreOffice calc. edit

Comments

2 Answers

Comments

Comments

Question Tools

Stats

Related questions

Bible verses collected, and sorted by books, chapters and verses, in a Biblical order in LibreOffice calc.