[Libreoffice-bugs] [Bug 111447] New: Calc FORMATTING Date YYYY-MM-DD is wrong in Dutch (BE) while ok in Dutch (NL)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=111447

            Bug ID: 111447
           Summary: Calc FORMATTING Date YYYY-MM-DD is wrong in Dutch (BE)
                    while ok in Dutch (NL)
           Product: LibreOffice
           Version: 5.3.4.2 release
          Hardware: IA64 (Itanium)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rdiependaele at netscape.net

Description:
In regio Flanders, in Belgium, we enter date as: DD-MM-JJJJ (JJJJ is Dutch for
YYYY).
For easy sorted lists we format the date automatically to JJJJMMDD
So, when entering in a cell f.e. 14/2/2017 Calc should display 20170214
That does not work for our language Dutch (BE).  Calc displays 14/2/2017
That does work for neighbour language Dutch (NL).  Calc displays 20170214



Steps to Reproduce:
1. cell format : category Date; layout JJJJMMDD (OR JJJJMMDD); Language Dutch
(Belgium)
2. cell input date, fe 14/2/2017
3. displays 14/2/2017 ans should display 20170214

Actual Results:  
date formatted in JJJJMMDD displays wrong for language Dutch (Belgium)

Expected Results:
I use Dutch (NL) to have the correct display of JJJJMMDD for my country (BE)


Reproducible: Always

User Profile Reset: No

Additional Info:
I add an attach to the bug:
LibreOffice_Calc_FormatDate-YYYYMMDD_Dutch-BE_Wrong.pdf


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/59.0.3071.115 Safari/537.36

-- 
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/20170807/b5ee2e6a/attachment-0001.html>