[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