<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Calc FORMATTING Date YYYY-MM-DD is wrong in Dutch" href="https://bugs.documentfoundation.org/show_bug.cgi?id=111447#c8">Comment # 8</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Calc FORMATTING Date YYYY-MM-DD is wrong in Dutch" href="https://bugs.documentfoundation.org/show_bug.cgi?id=111447">bug 111447</a> from <a class="email" href="mailto:rdiependaele@netscape.net" title="rdiependaele@netscape.net">rdiependaele@netscape.net</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=135295" name="attach_135295" title="Calc Format Date JJJJ-MM-DD Local Date Delimiter Displays Not">attachment 135295</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=135295&action=edit" title="Calc Format Date JJJJ-MM-DD Local Date Delimiter Displays Not">[details]</a> Calc Format Date JJJJ-MM-DD Local Date Delimiter Displays Not In calc, options, I changed the Dutch (BE) Local Date Delimiter from D/M/J into D-M-J formatted a cell to JJJJ-MM-DD entered 7-8-2017 expected 2017-08-07 result 7-8-2017 This is very confusing, even if it shouldn't be a bug. See: LibreOffice_Calc_FormatDate_JJJJ-MM-DD_Local-DateDelimiter_DisplaysNot.pdf and LibreOffice_Calc_FormatDate_JJJJ-MM-DD_Local-DateDelimiter_DisplaysNot.ods</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>