Bug 81786 - UI Language list not sorted by displayed language name, but by language code (that is invisible to the user)
Summary: UI Language list not sorted by displayed language name, but by language code ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
4.3.0.3 rc
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Installer
  Show dependency treegraph
 
Reported: 2014-07-26 16:37 UTC by Urmas
Modified: 2024-09-04 12:47 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


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

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 4.3.0.4 (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 4.4.2.2 (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 5.0.4.2 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
Persists
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
Persists
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 7.3.5.2 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 7.3.5.2 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.
Comment 19 Cor Nouws 2024-09-04 12:46:14 UTC
This is a more generic issue - just stumbled over it when looking up Dutch to set spell checking..

(In reply to Ulrich Windl from comment #18)
> Using the German Windows installer of 7.3.5.2 the list of dictionary
> languages is sorted by language code or by English translation, but NOT by
> the displayed translation.
Indeed.
https://opengrok.libreoffice.org/xref/core/i18nlangtag/source/isolang/isolang.cxx?r=8a11d2e0