Bug 90641 - Cannot sort bibliography entries in the Writer GUI and the Insert dialogue
Summary: Cannot sort bibliography entries in the Writer GUI and the Insert dialogue
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium enhancement
Assignee: Andreas Heinisch
Whiteboard: target:7.6.0
Depends on:
Blocks: Bibliography
  Show dependency treegraph
Reported: 2015-04-15 19:49 UTC by thanasis57
Modified: 2022-12-21 10:08 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description thanasis57 2015-04-15 19:49:31 UTC
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:
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?
Comment 1 Buovjaga 2015-04-18 12:20:51 UTC
Sounds reasonable -> NEW.
Comment 2 Heiko Tietze 2016-08-02 14:44:07 UTC
Duplicate of bug 65907?
Comment 3 Stéphane Guillou (stragu) 2021-06-12 13:04:37 UTC
reproduced in:

Version: / 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
Comment 4 Commit Notification 2022-12-21 10:08:15 UTC
Andreas Heinisch committed a patch related to this issue.
It has been pushed to "master":


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:

Affected users are encouraged to test the fix and report feedback.