Steps: 1) Open calc 2) type 1234 in a cell 3) Open the formatting dialog 4) Select currency in the category 5) Select EUR in the format 6) Notice that only the first 2 entries have EUR in them while the rest are $ and if you select one of the $ entries, it will change to USD$ in the format drop down Version: 4.5.0.0.alpha0+ Build ID: 4cf69df2f543b023f4ec3d4279c5ac11a2a819d9 TinderBox: Linux-rpm_deb-x86@45-TDF, Branch:master, Time: 2015-02-21_03:46:34 I had noticed this issue from the following tweet. https://twitter.com/Regiteric/status/573225294909345793/photo/1
On pc Debian x86-64 with master sources updated today, I don't reproduce it. Even better! I can select Eur French France and got some Euros format + F/FRF (former French "Franc" currency)! If I change localization to German Germany then select Eur Germany, I've got Euros format + DM/DEM format (former German currency "Deutsche Mark") :-)
Created attachment 113936 [details] printscreen of bug I can confirm with Version: 4.5.0.0.alpha0+ Build ID: 2c0e1917c18711d6762e12042794b745f08cf62f TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-03-05_17:29:19 Locale: cs_CZ
Let's put expert in cc. Eike: Calc + currency format related, thought you might be interested in this one..
This is intended behavior. The listing depends on the current system locale. The selected currency (EUR in this case) is used to create *additional* entries to the locale ones and formats them with the current locale's rules and separators.
At the lower portion of the currency drop down, they have individual currencies not related to locales and when EUR is selected there, it does not provide the same entries available when you select, for example, EUR € German. When you select EUR € German, you can select -1,234 €, but this option is not available in EUR. You are not even given -1,234 EUR.
That is because the entries for currencies without locales provide only the ISO 4217 currency codes. Note also the difference in the format codes. Also, only the currencies' number of decimals is presented, no truncated formats. These formats are commonly used for accounting and currency exchange purposes. You get the same when selecting a locale's currency, but without cluttering the list with further locale dependent formats that use the currency symbol.
In the case of the Euro, there should be an entry in the list that provides the currency symbol and currency code which is not associated with a locale, as it is cross-country currency.