https://bugs.documentfoundation.org/show_bug.cgi?id=111447
--- Comment #19 from [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 (14th of February 2017) Calc should
display 20170214
2017 August :
Windows7 Pro Full Patched
LibreOffice V5.3.4.2
Starting Calc from:
the PortableApp Menu Item LibreOffice
Date accept pattern: D-M-Y;D-M;
Default Language: Nederlands (Belgie)
Starting Calc from:
File Browser: RightClick on .ods>Open
Date accept pattern: D/M/Y;D/M
Default Language: Standaard - Nederlands (Belgie)
That did not work (2017 August) for our language Dutch (BE). Calc displayed
14/2/2017
That did work (2017 August) for neighbour language Dutch (NL). Calc displayed
20170214
Steps to Reproduce (2017 August):
1. cell format : category Date; layout JJJJMMDD; Language Dutch (Belgium)
2. cell input date, fe 14/2/2017
3. displays 14/2/2017 and should display 20170214
Actual Results (2017 August):
date formatted in JJJJMMDD displays wrong for language Dutch (Belgium)
Expected Results (2017 August):
I used Dutch (NL) to have the correct display of JJJJMMDD for my country (BE)
======
2019 November :
Windows10 Pro Full Patched
LibreOffice V6.2.5.2 (x86)
Starting Calc from:
the PortableApp Menu Item LibreOffice or the File Browser: RightClick on
.ods>Open
Date accept pattern: D-M-Y;D-M;
Default Language: Nederlands (Belgie)
Steps to Reproduce (2019 November):
1. cell format : category Date; layout JJJJMMDD; Language Dutch (Belgium)
2. cell input date, fe 4/11/2019
3. displays 20191104
I dont know why this is RESOLVED now: version upgrade Winodws or
LibreOffice...?!
This case Bug 111447, is RESOLVED and CLOSED for me.
--
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
