Created attachment 165614 [details] current situation I tried to format numbers as currency in Calc. As I live in the Dutch speaking part of Belgium I wanted to use the format option Dutch (Belgium) or Nederlands (België). If I use this, the euro sign is placed after the number. This is not correct. As in the Netherlands (where format is correct..) the currency symbol is placed before the number. For those who can read Dutch, these are the official rules: https://taaladvies.net/taal/advies/vraag/1178
Looking at the locale data for Dutch (Belgium), it seems the currency symbol is indeed put after the numbers in the format: https://opengrok.libreoffice.org/xref/core/i18npool/source/localedata/data/nl_BE.xml?r=8453f6e5#89 However I don't speak Dutch and can't read the official rules provided by the reporter. @Eike, I think you may be interested in this one.
A quick translation of these rules: Currency symbols, such as the symbols for the British pound (£), the dollar ($), the Japanese yen (¥) and the euro (€), are placed before the stated amount in the Dutch language area, with a space after the currency symbol. For example: € 26.37; £ 896.12. This applies both in plain text and in lists or tables. Flanders is part of the Dutch language area, so these rules apply to how we use currency symbols in Dutch (BE).
(In reply to Roeland from comment #2) > A quick translation of these rules: [translation snipped] It's going to be Eike's call, but my take -- for whatever it's worth -- is that the content of that rules page doesn't matter much, since I trust you on this simple "symbol before or after numbers" issue, and even I don't, there are plenty of translation tools on the web. What matters is how authorative/official that page is. Does Belgium government have an administrative office for such things? If not, which organization is responsible for such rules, and are they widely accepted by the people? In my opinion these are more important things and can't be easily inferred from a single webpage.
Hi Ming Hua. Taaladvies (language advice) is set up bij the Taalunie (Language Union). The Taalunie sets the rules for de Dutch speaking world (Netherlands, Flanders, Suriname). These rules are endorsed by both governments and used as guidance in any text written in Dutch.
To read more about the Taalunie see: https://en.m.wikipedia.org/wiki/Dutch_Language_Union
@Cor, I thought you might be interested in this issue or you might know someone who is
While many multiple languages per country follow the country's rule, this one seems not. See also https://icu4c-demos.unicode.org/icu-bin/locexp?d_=en&_=nl_BE
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a66653805782df67431c462bf8f890a154066cf0 Resolves: tdf#136839 {nl-BE} leading currency symbol It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.