Bug 98403 - UGX currency displayed as “Ganda”
Summary: UGX currency displayed as “Ganda”
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Localization (show other bugs)
Version:
(earliest affected)
7.0.3.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: User-Locale
  Show dependency treegraph
 
Reported: 2016-03-04 07:44 UTC by Diarmuid O'Briain
Modified: 2023-05-11 12:16 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
UGX currency select (87.99 KB, image/png)
2016-03-04 07:44 UTC, Diarmuid O'Briain
Details
There is no country called Ganda but there is a country called Uganda (182.10 KB, image/png)
2021-02-05 08:38 UTC, Diarmuid O'Briain
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Diarmuid O'Briain 2016-03-04 07:44:04 UTC
Created attachment 123221 [details]
UGX currency select

Hi,

In Format cells -> Category -> Currency -> Format -> "UGX USh Ghana"

The UGX/USh currency is incorrectly labeled as "Ghana", it should be labeled "Uganda". i.e. Ugandan Shilling.

The currency in Ghana is the Cedi (GHS) and it is correctly labeled in the dropdown.

regards,
xcsd
Diarmuid
Comment 1 Julien Nabet 2016-03-04 19:39:30 UTC
The screenshot you attached shows "Ganda", not "Ghana"

So, should it be "UGX USh Uganda" or "UGX USh Ganda" is ok?
Comment 2 Diarmuid O'Briain 2016-03-04 21:45:38 UTC
It should be labelled:

"UGX USh Uganda"
Comment 3 Julien Nabet 2016-03-05 08:26:47 UTC
I submitted a patch to review here:
https://gerrit.libreoffice.org/#/c/22926/

Just for curiosity, why then have you talked about Ghana whereas it wasn't related to the screenshot?
Comment 4 Commit Notification 2016-03-05 11:35:25 UTC
Julien Nabet committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=42032f5d3b960185a9e4b1b63680af0ae27dca2d

tdf#98403: UGX Currency is "Uganda" not "Ganda"

It will be available in 5.2.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 5 Julien Nabet 2016-03-05 14:13:23 UTC
Diarmuid: Adolfo (put in cc), proposes "Ugandan" instead of "Uganda", see comment in https://gerrit.libreoffice.org/#/c/22926/
It makes sense to me, any thoughts?
Comment 6 Diarmuid O'Briain 2016-03-05 15:04:08 UTC
That is fine by me, just want to see the correct country against the currency.
Comment 7 Commit Notification 2016-03-05 16:39:30 UTC
Julien Nabet committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=da75a89925bce029c9464586ebf73e18e0342a9e

tdf#98403: "Ugandan" is better than "Uganda"

It will be available in 5.2.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 8 Adolfo Jayme Barrientos 2016-03-05 17:17:45 UTC
OK, so that drop-down box is reusing language names for currency.

“Ganda” is a valid alternative name for Luganda, one of the major languages in use in Uganda.

I’ve now realized that by suggesting “Ugandan” we’re now inaccurately referring to the (Lu)ganda language, since the word “Ugandan” can be used to encompass all of the languages used in the country (https://en.wikipedia.org/wiki/Languages_of_Uganda). This may turn out to be an issue later on. A proper fix would be for this drop-down to contain the actual, full names of the currencies. Maybe we could use ICU to retrieve the currency names. @Eike, any ideas?
Comment 9 Commit Notification 2016-03-08 18:42:44 UTC
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=6f6c21ad91d10f160ab904985cfcaefd98102636

Revert "tdf#98403: "Ugandan" is better than "Uganda""

It will be available in 5.2.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 10 Commit Notification 2016-03-08 18:42:48 UTC
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=0947c9be4d09999a9bd3842fbd66690572c40eee

Revert "tdf#98403: UGX Currency is "Uganda" not "Ganda""

It will be available in 5.2.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 11 Julien Nabet 2016-03-08 18:44:49 UTC
My fix was wrong, I don't know how to fix this.
Certainly someone will know.
Comment 12 Eike Rathke 2016-03-08 18:58:20 UTC
As noted, langtab.src lists language/locale names, which are reused in the currency list. It is wrong to change that name from Ganda to Ugandan.

Our locale data also provides a currency name in the <CurrencyName> element, which for lg-UG is "Silingi", but that is not part of localization so could only be offered as is.

It might be possible to use ICU currency names, but also those may not be translated in all languages we provide localization for, additionally it might not provide names for all currencies we offer from our locales, needs to be checked. It might be it provides a full list of ISO 4217 currency codes.
Comment 13 QA Administrators 2017-05-22 13:20:26 UTC Comment hidden (obsolete)
Comment 14 Diarmuid O'Briain 2017-05-22 13:40:22 UTC
As per request, I have tested with 5.3.3 and the bug still exists. This is a simple bug to fix, it is a text field that is for all intents and purposes spelt wrong. 

Kernel: 4.4.0-75-generic x86_64 (64 bit) 
Desktop: Cinnamon 3.2.7
Distro: Linux Mint 18.1 Serena
Comment 15 Eike Rathke 2017-05-24 22:30:38 UTC
(In reply to Diarmuid O'Briain from comment #14)
> This is a simple bug to fix.
Actually reading the previous comment 12 you could had deduced that this is not trivial to fix.
Comment 16 Diarmuid O'Briain 2018-02-04 11:34:31 UTC
This problem was not resolved when reported and still exists in the new 6.0.0.3 release. There is only one currency in Uganda (the country where the Ludandans are only one tribe of many live) UGX or USh for Uganda Shilling and 42 local languages from 23 language groups. It is obviously not a good idea to tie language and currency together unless you are prepared to have a many to one relationship. The fact is there is no Ganda currency, there is a Uganda currency issued by the Bank of Uganda which was established in 1966, by Act of Parliament of the Ugandan government. ISO 4217 assigns the Ugandan currency the alphabetic code "UGX" and the numeric code "800" and the currency name "Ugandan shilling". 

The Ganda people (Bugandans) only represent 16% of the population of Uganda. If you are worried about linking Uganda with UGX/USh and want to maintain the  Ganda then you need to add the following list or you are disenfranchising 84% of the Ugandan population or about 30 million people.

UGX USh Acholi
UGX USh Adhola
UGX USh Alur
UGX USh Aringa
UGX USh Bari
UGX USh Elgon
UGX USh Ganda
UGX USh Ik
UGX USh Karamojong
UGX USh Kiga
UGX USh Kuman
UGX USh Lango
UGX USh Lugbara
UGX USh Lussese
UGX USh Ma'di
UGX USh Ndo
UGX USh Nkole
UGX USh Nyoro
UGX USh Pokot
UGX USh Soga 
UGX USh Soo
UGX USh Teso
UGX USh Tooro

By the way I noticed (and raised a different ticket for it, but the Kenyan Shilling (KES) is not available at all.
Comment 17 QA Administrators 2019-02-05 03:46:18 UTC Comment hidden (obsolete)
Comment 18 QA Administrators 2021-02-05 04:13:01 UTC Comment hidden (obsolete)
Comment 19 Diarmuid O'Briain 2021-02-05 08:37:53 UTC
This bug is still alive and well, 5 years after I logged it. It might be better to fix it instead of emailing me after every major version release expecting I will test and find it has magically fixed itself. 

Version: 7.0.3.1
Build ID: 00(Build:1)
CPU threads: 2; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: en-IE (en_IE.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.3-0ubuntu0.20.10.1
Calc: threaded
Comment 20 Diarmuid O'Briain 2021-02-05 08:38:48 UTC
Created attachment 169490 [details]
There is no country called Ganda but there is a country called Uganda
Comment 21 Julien Nabet 2021-02-05 10:47:12 UTC
Since 2018, there has been 1 automatic email in 2019 and 1 2021, I don't consider this as a spam.
For the rest, I can't help here=>uncc myself.
Comment 22 Eike Rathke 2021-02-05 11:47:59 UTC
(In reply to Diarmuid O'Briain from comment #20)
> There is no country called Ganda but there is a country called Uganda
There's the language Ganda spoken in Uganda, which forms the locale of which the currency is taken, the currency list is merged from currency + language/locale name, as already explained in comment 12.
Comment 23 QA Administrators 2023-02-06 03:19:29 UTC
Dear Diarmuid O'Briain,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug