When we enter bibliography entries we use a LO Writer GUI that writes to the database itself (Tools -> Bibliography database) When we insert a new entry in the text, we use a special "Insert dialogue" (Insert -> Indexes and Tables -> Bibliography entry) The order of the database entries in both cases is the one with which we entered them and we have no way to sort them (e.g. alphabetically by the Identifier field). This can be debilitating in some cases. E.g., I have a long text (~700 pages, ~500 references) and I built the bibliography database after finishing the text. I parsed each page of the text and entered each bibliography reference as I came across it. Of course, the identifiers of each of these references (usually author last names) were not kind enough to be in alphabetical order. So at the "Insert dialogue" I am faced with an unsorted list of ~500 entries. No way to work with something like that. There should be a way to sort that list so that we can then work with it. Steps to reproduce: 1. Create text and create e.g. 5 bibliography entries (Tools -> Bibliography database) with identifiers: "orange", "banana", "apple", "kiwi", "grapefruit" (in that order). 2. Try to insert each of these entries somewhere in the text (Insert -> Indexes and Tables -> Bibliography entry -> From bibliography database). You will be faced with the following list: orange banana apple kiwi grapefruit This list is on random alphabetical order. 3. Multiply x100 and you get the point. PS: Apparently (?), each entry has a hidden field which identifies its order of appearence and it seems to be unique. Could this be useful for bug #60232?
Sounds reasonable -> NEW.
Duplicate of bug 65907?
reproduced in: Version: 7.2.0.0.alpha1+ / LibreOffice Community Build ID: bb54d6d8241a06a6772052b77b67d6a4f686426c CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-06-11_20:14:38 Calc: threaded
Andreas Heinisch committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/9b1c218c9a4f09cac33fba24712bb9af029f2ea9 tdf#90641 - Insert bibliography dialog: sort entries by identifier It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.