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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat May 4 15:52:23 UTC 2019


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

--- Comment #6 from Mike Kaganski <mikekaganski at hotmail.com> ---
Created attachment 151179
  --> https://bugs.documentfoundation.org/attachment.cgi?id=151179&action=edit
Screencast of Excel 2016 swapping date parts on input

(In reply to SStefanek from comment #5)
> 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.

-- 
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/deed31c0/attachment-0001.html>


More information about the Libreoffice-bugs mailing list