<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#c3">Comment # 3</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#c2">comment #2</a>) > and really no software does that Wrong. MS Excel (the major spreadsheet software) does that; that's the industry standard. > Analogy: if a form accepts a price in euro everyone is expected to type > euros in there. This is valid also for users that live in USA and have > dollars as "system" currency. Your analogy is wrong. Spreadsheet is not a form itself. *Format string* is never used to interpret the input (other than when it tells that the cell is text, so no interpretation at all is needed), because format string may be however complex, with different parts, and even invalid itself. Formatting is related to display, not to input. > Another thing I see now is that it's not consistent. Typing in a date like > 21/12/2001 will NOT swap day and month. Very hard to use. It *is* consistent. When you type it like that, it's treated as invalid date, and then simply not converted to date at all, staying string (and then you can't use it in calculations like finding date difference etc).</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>