[Libreoffice-bugs] [Bug 111447] Calc FORMATTING Date JJJJ-MM-DD with changed local date delimiter '-' goes wrong

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Nov 4 13:41:00 UTC 2019


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

--- Comment #19 from 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 (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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191104/0fd291e9/attachment.html>


More information about the Libreoffice-bugs mailing list