[Libreoffice-bugs] [Bug 125109] Calc inverts typed dates

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125109

--- Comment #3 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to SStefanek from comment #2)
> 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).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190504/10081622/attachment.html>