<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#c9">Comment # 9</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=135296" name="attach_135296" title="Calc Format Date JJJJ-MM-DD Local Date Delimiter Displays Not (as .ods)">attachment 135296</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=135296&action=edit" title="Calc Format Date JJJJ-MM-DD Local Date Delimiter Displays Not (as .ods)">[details]</a> Calc Format Date JJJJ-MM-DD Local Date Delimiter Displays Not (as .ods) 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>