https://bugs.documentfoundation.org/show_bug.cgi?id=119613
Bug ID: 119613
Summary: FORMATTING Incorrect number and date format for South
Africa (en_ZA)
Product: LibreOffice
Version: 6.0.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: documentfoundat...@mohag.net
Description:
(I'm assuming other South African languages are also affected)
LibreOffice Calc incorrectly uses decimal dots and commas as thousands
separators when cells are formatted as currency or numbers.
South Africa officially uses decimal commas (dots are in common, incorrect use
though and many applications require it) and spaces as the thousands grouping
symbol. (Decimal points can be lived with, however commas for grouping creates
confusion)
A blog post with several sources:
https://sadev.co.za/content/how-correctly-format-currency-south-africa
A government style guide:
https://www.gcis.gov.za/sites/default/files/editorial_styleguide_2011.pdf
The date format also defaults to YY/MM/DD, instead of the correct ISO-8601
format. See the description from this standard:
https://store.sabs.co.za/catalog/product/view/id/216987/s/sans-8601-2009-ed-2-00/
Steps to Reproduce:
1. For numbers, enter 123456.12 (use numpad for decimal)
2. Click format as number on toolbar. Click format as Currency to view in
currency as well.
3. Enter a date "Mar 2018".
Actual Results:
123,456.12
R 123,456.12
18/03/01
Expected Results:
123 456,12
R 123 456,12
2018-03-01
Reproducible: Always
User Profile Reset: No
Additional Info:
Computer running Windows 10 1803, set to English (South Africa)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
