[Libreoffice-bugs] [Bug 119613] New: FORMATTING Incorrect number and date format for South Africa (en_ZA)

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: documentfoundation at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180830/bb5dc84d/attachment.html>