| Summary: | wrong formatting of currency when using Dutch (Belgium) | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Roeland <roelandboie> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | cno, erack, ming.v.hua, xiscofauli |
| Priority: | medium | ||
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:7.2.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | current situation | ||
|
Description
Roeland
2020-09-17 09:46:55 UTC
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. |