<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Calc inverts typed dates" href="https://bugs.documentfoundation.org/show_bug.cgi?id=125109#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Calc inverts typed dates" href="https://bugs.documentfoundation.org/show_bug.cgi?id=125109">bug 125109</a> from <a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=151179" name="attach_151179" title="Screencast of Excel 2016 swapping date parts on input">attachment 151179</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=151179&action=edit" title="Screencast of Excel 2016 swapping date parts on input">[details]</a> Screencast of Excel 2016 swapping date parts on input (In reply to SStefanek from <a href="show_bug.cgi?id=125109#c5">comment #5</a>) > Nope. I have just tried and Excel does not override my input. It may not > interpret it as date unless typed in the way it expects but that's a > different story. Previous versions of Calc didn't do that either: it started > swapping dates with a recent update. Here you can see this in action. I'm Russian, and use Russian locale (D/M/Y); so I did just the opposite: I set the cells to en-US, and then entered the date, so you may see that the date as I entered (1.3.2019) converted to 3.1.2019 on entry. So I see that Excel indeed does that.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>