https://bugs.documentfoundation.org/show_bug.cgi?id=63536
--- Comment #9 from Laurent BP <[email protected]> ---
LibO, with en-US and en_GB locales, already contains two currency formats with
left justify currency symbol and right justify decimal number:
[$$-409]* #,##0;-[$$-409]* #,##0
[$$-409]* #,##0.00;-[$$-409]* #,##0.00
These formats are defined in
http://opengrok.libreoffice.org/xref/core/i18npool/source/localedata/data/en_US.xml#113
<FormatElement msgid="CurrencyFormatskey7" default="false" type="short"
<FormatCode>[CURRENCY]* #,##0;-[CURRENCY]* #,##0</FormatCode>
</FormatElement>
<FormatElement msgid="CurrencyFormatskey8" default="false" type="medium"
usage="CURRENCY" formatindex="83">
<FormatCode>[CURRENCY]* #,##0.00;-[CURRENCY]* #,##0.00</FormatCode>
</FormatElement>
This was added 4 years ago:
https://cgit.freedesktop.org/libreoffice/core/commit?id=84c54990c0dbd3385a4a653afe63d0fa7b1c435b
We may add some more formats but we need some references: currency unit can be
on left or right, negative numbers can be in red or not, with a minus sign or
with parentheses, zeros can be displayed as --, etc. There are many
possibilities depending on locales acceptance rules.
As I have no accounting capacities, I looked to other spreadsheet for fr-FR:
Gnumeric proposes:
_(0,00* [$€-1]_);_((0,00)* [$€-1];_("-"??* [$€-1]_);_(@_)
Excel 2010:
_-* # ##0,00 €_-;-* # ##0,00 €_-;_-* "-"?? €_-;_-@_-
I would prefer Excel proposition as there is thousand separator and decimal are
aligned.
According to help
https://support.office.com/en-US/article/Format-numbers-as-currency-0A03BB38-1A07-458D-9E30-2B54366BC7A4
Accounting format for en-US in Excel may look like:
[$$-409]* #,##0.00_);[$$-409]* (#,##0.00);[$$-409]* -_);_(@_)
This has to be defined for each locale which needs an accounting format. There
are 198 XML files in
http://opengrok.libreoffice.org/xref/core/i18npool/source/localedata/data to be
modified. But they can be modified one after one, when localization teams
decide what is the best format for each.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
