[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