<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_CLOSED bz_closed"
title="CLOSED NOTABUG - Calc FORMATTING Date JJJJ-MM-DD with changed local date delimiter '-' goes wrong"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111447#c19">Comment # 19</a>
on <a class="bz_bug_link
bz_status_CLOSED bz_closed"
title="CLOSED NOTABUG - Calc FORMATTING Date JJJJ-MM-DD with changed local date delimiter '-' goes wrong"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111447">bug 111447</a>
from <span class="vcard"><a class="email" href="mailto:rdiependaele@netscape.net" title="rdiependaele@netscape.net">rdiependaele@netscape.net</a>
</span></b>
<pre>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 <a class="bz_bug_link
bz_status_CLOSED bz_closed"
title="CLOSED NOTABUG - Calc FORMATTING Date JJJJ-MM-DD with changed local date delimiter '-' goes wrong"
href="show_bug.cgi?id=111447">Bug 111447</a>, is RESOLVED and CLOSED for me.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>