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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
