<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#c11">Comment # 11</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:s.stefanek@gmail.com" title="Szymon Tomasz Stefanek <s.stefanek@gmail.com>"> Szymon Tomasz Stefanek</a> <pre>One of the comments in <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - Date format setting not recognised" href="show_bug.cgi?id=116579">tdf#116579</a> made me notice another nasty side effect. - I enter 01/02/2019 into an empty cell. - The day and month gets swapped and we get 02/01/2019. Let's say it's OK. - Then I realize that 2019 is wrong - I wanted it to be 2018 - I enter edit mode by double clicking, change the year only and press enter - The day and month gets swapped again and we have 01/02/2018 now To allow editing cell without the users going crazy the current cell format must be taken into account as first. Only if it does not lead to a recognizable date then other formats can be tried.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>