<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#c8">Comment # 8</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>(In reply to SStefanek from <a href="show_bug.cgi?id=125109#c7">comment #7</a>) > So on windows with Excel it's a matter of system date settings. True. > Calc on windows has a different behavior. With global English locale and > system date format YYYY-MM-DD it still interprets XX/YY/ZZZZ input as > MM/DD/YYYY regardless of what format is set on the cell (unless MM is > greater than 12). So I guess that the system setting is honored only > partially: global locale is used but specific date format is ignored. LibreOffice does not take system locale into consideration "completely". Well - sorts of: LibreOffice uses system locale to detect the *default* locale - if user doesn't set LibreOffice locale to some explicit value in Options->Language Settings->Languages. And then, it doesn't take into account any OS-specific additional settings, like intl.cpl settings other than language on Windows, or LC_TIME on Linux. There's an enhancement request on that; but it has never worked differently with LO/OOo. LO had introduced accepted date formats to allow users to fine-tune what is accepted as date.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>