[Libreoffice-bugs] [Bug 143165] [EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Jul 3 00:09:21 UTC 2021


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

--- Comment #7 from Ming Hua <ming.v.hua at qq.com> ---
FWIW, when switched to en-US locale, and the date acceptance pattern is just
"M/D/Y;M/D", input "5-D" doesn't trigger this bug anymore, but "5/D" still
does.  Similarly, input "5/D/Y" is also converted, to "7/5/21", which means
"July 5th, 2021".  Input "5/7/Y" is properly converted to "5/7/21", which means
"May 7th, 2021".  Input "M/5" or "M/5/Y" is not converted.

Something is definitely wrong here.

-- 
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/20210703/c49eb7f4/attachment.htm>


More information about the Libreoffice-bugs mailing list