In the German locale of LibreOffice 3.5.1 the default currency is still DM instead of EUR. I believe this is just a outdated setting in Calc. Steps to reproduce: * Open Calc * Right mouse click on any cell * Choose "Numbers" -> "Currency" * and choose in the scroll bar "Format" the currency "Automatically" * The chosen currency is DM which is wrong since the Euro was introduced in 2002. Thanks for fixing this trivial bug!
I cannot reproduce your problem. Could you please give more details, operating system, locale settings, etc.?
Thanks Andras for looking into it. The LibreOffice version is 3.5.2 from the Ubuntu PPA, Ubuntu 11.10 64-Bit, German locale de-DE. However, I believe that the OS does not make a difference. Here the information from Tools -> Options -> Language Settings -> Languages: User Interface: English (UK) Locale Setting: English (UK) Default currency: EUR € German (Germany) Default language for documents; Default-English (UK) Do you need any other information?
Created attachment 60021 [details] Example-wrong-default-currency-Austrian-Shillings.jpg Some more additions: Please find attached a screen shot which shows the same problem with German (Austria) in the currency-format dialog. If you choose in the pull down menu "Automatically", the currency goes wrongly to Austrian shillings. I tried some more Euro-countries and apparently it was forgotten after 2002 to change the automatic default currencies, e.g. French (France) redirects automatically to F instead of Euro French (Luxembourg) redirects to F French (Belgium) redirects to FB German (Austria) redirects to öS German (Germany) redirects to DM Italian (Italy) redirects to ₤ (Lira)
@Eike: in i18pool/source/localedata/data xml files for Euro countries still contain old currencies as default in FormatElements used for currency. Is this intentional, or does it need to be fixed? E.g. in de_AT.xml <FormatElement msgid="CurrencyFormatskey1" default="true" type="short" usage="CURRENCY" formatindex="12"> <FormatCode>[$öS-C07] #.##0;-[$öS-C07] #.##0</FormatCode> </FormatElement>
This is on purpose. It is for backwards compatibility with legacy documents where "Automatically" was used and resulted in the legacy currency, you certainly don't want that to suddenly display Euro instead ... If loaded in another locale and the original locale of the number format was system (and not fixed to a specific locale) the currency changes as well, this is all crap ... In fact the "Automatically" currency format should not be used nowadays, there is no easy way to get rid of it though, as legacy documents still need it. The actual default currency format is determined differently and obtained from the LC_CURRENCY Currency elements that are correct and replace the symbol in the currency FormatCode elements. Taking this bug as a placeholder. Maybe there's a way to offer the format only if it is used.
Thanks Eike, I learnt that a "trivial correction" is not necessarily trivial :-)
This bug hasn't seen any action in a very long time. Freeing this bug and switching ASSIGNED to NEW Eike if you are still working on this, please re-assign yourself. Or can this bug be closed already?
The task to display the "automatic currency" format entry only if it is used by the current document content still needs to be done.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2e3d7c742a1c1253c4bb2af1c3d1b1506d2e7af4 fdo#48110 disable the "Automatically" currency unless already used 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.
Pending review for 4-3 at https://gerrit.libreoffice.org/10939
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2d52a907e26c306fa6738766409df2d7760fe3c4&h=libreoffice-4-3 fdo#48110 disable the "Automatically" currency unless already used It will be available in LibreOffice 4.3.2. 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.