Bug 81786 - UI Language list not sorted
Summary: UI Language list not sorted
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Installation (show other bugs)
(earliest affected) rc
Hardware: Other All
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: Installer
  Show dependency treegraph
Reported: 2014-07-26 16:37 UTC by Urmas
Modified: 2022-09-07 20:35 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

screenshot of issue (51.12 KB, image/jpeg)
2015-04-22 12:10 UTC, Michael Bauer
new screenshot (6.01 KB, image/png)
2015-12-28 14:42 UTC, Michael Bauer
Screenshot of Windows Installer (54.54 KB, image/jpeg)
2022-09-07 20:35 UTC, Ulrich Windl

Note You need to log in before you can comment on or make changes to this bug.
Description Urmas 2014-07-26 16:37:00 UTC
Attempting to install rc3 in Win8 x64, Russian localization, UI language list is not sorted alphabetically.
Apparently sorting is performed by language codes, which is very weird.
Comment 1 Urmas 2014-07-26 16:40:08 UTC
UPDATE: The dictionaries list is sorted in the same way.
Comment 2 A (Andy) 2014-08-01 21:59:47 UTC
for me not reproducible with LO (Win 8.1, German)
Comment 3 Urmas 2014-08-02 01:47:34 UTC
In German locale it is also unsorted. 'Weißrussisch' comes before 'Bulgarisch'.
Comment 4 steve 2014-10-27 12:47:16 UTC
Could you post a screenshot of the wrong listing?
Do I have to install more than one language to see this happening? Under LO > Preferences > Language Settings > Languages > User Interface I just see English (USA).

After providing more info please back to unconfirmed.
Comment 5 Andras Timar 2014-10-27 14:44:01 UTC
Well, I don't know how much it would help, if Urmas sent a screenshot. I can imagine such screenshot without sending and I believe that what he says is true. I could not reproduce the problem on Windows 8.1 and as the author of the sorting feature, I have no idea why it would not work in certain circumstances. 

See the code at http://opengrok.libreoffice.org/xref/core/setup_native/source/win32/customactions/sellang/sorttree.cxx -- it is as simple as it could be.

I'm afraid, if we don't get more confirmations or insightful explanation to the bug, we have to close it as WORKSFORME.
Comment 6 Michael Bauer 2015-04-22 12:10:15 UTC
Created attachment 115005 [details]
screenshot of issue

Confirmed during installation of (using the default English Windows installer as there isn't a localized one for gd).
The list is clearly sorted by ISO codes which is not helpful, it puts Welsh (cy) right after Czech (cz) and Greek (he) before English (en).
These should be sorted according to the script the installer is using i.e. for Latin script based installers like English it should sort
Czech (cz)
English (en)
Greek (he)
Welsh (cy)

For Russian
английский (en)
валлийский (cy)
греческий (he)
чешский (cz)

For Chinese radical + stroke number (same as Excel for example) 
威爾士語 (cy)
希臘語 (he)
捷克語 (cz)
英語 (en)
Comment 7 QA Administrators 2015-12-27 20:31:25 UTC Comment hidden (obsolete)
Comment 8 Michael Bauer 2015-12-28 14:42:34 UTC
Created attachment 121579 [details]
new screenshot

The bug persists, this is from the installation dialogue on Windows.
Comment 9 Michael Bauer 2015-12-28 14:48:06 UTC
I'm beginning to wonder if this is related to that infernal conflict between installed keyboard languages and programs/apps when it comes to language selection. My OS has a Gaelic langpack and 4 installed keyboard locales. Urmas & Andras, what is your OS setup?

Could it be that LO somehow pulls the sort order from the OS or keyboard locale but if there is more than one, it defaults somehow to sorting by ISO code?

The reason I'm wondering is because in MS Office, if you have more than one keyboard locale installed, even when you switch OFF the Detect Language feature, it gets totally confused and assigns language/locale in a very random fashion.
Comment 10 QA Administrators 2017-01-03 19:55:37 UTC Comment hidden (obsolete)
Comment 11 Michael Bauer 2017-01-03 22:51:09 UTC
Comment 12 QA Administrators 2018-01-04 03:35:17 UTC Comment hidden (obsolete)
Comment 13 Michael Bauer 2018-01-04 11:50:39 UTC
Comment 14 QA Administrators 2019-01-05 03:41:48 UTC Comment hidden (obsolete)
Comment 15 Michael Bauer 2019-01-06 13:11:49 UTC
Persists. This is not one of those bugs that will go away on its own...
Comment 16 QA Administrators 2022-08-15 03:45:05 UTC Comment hidden (obsolete)
Comment 17 Michael Bauer 2022-08-15 08:56:59 UTC
In the localized (gd-GB) version of the installer of 7.3.5, the list is sorted alphabetically. But I can't speak for the English installer.
Comment 18 Ulrich Windl 2022-09-07 20:35:13 UTC
Created attachment 182293 [details]
Screenshot of Windows Installer

(In reply to Michael Bauer from comment #17)
> In the localized (gd-GB) version of the installer of 7.3.5, the list is
> sorted alphabetically. But I can't speak for the English installer.

Using the German Windows installer of the list of dictionary languages is sorted by language code or by English translation, but NOT by the displayed translation.

In the screenshot you see that "Deutsch" is sorted like staring with a "G" (German), and "Schottisch-Gälisch" is also sorted like starting with "G" (Gaelic?), just as "Ungarisch" is sorted like starting with "H" (Hungarian).

What surprises me most is that this bug survived so many years.
Beginners searching for a language in the ever-growing list will be surprised in a negative way, I guess.