[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]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com

--- Comment #5 from Mike Kaganski <mikekaganski at hotmail.com> ---
I am reasonably sure this is not a bug, and 5-d likely is a valid date pattern
in your locale, which means that for any cell formatted as number, the text is
automatically recognized and converted to the date value.

If this is the case, you should not play with autocorrect options (because what
you see is *not* autocorrection, but recognition of numeric data), and instead
simply pre-format your cells where you put textual data as Text (Format
Cells->Numbers; select Text category). This makes sure that the data you enter
is not attempted to be converted to numbers.

There's some chance that I'm wrong, and 5-d is *not* a valid date pattern for
your locale; maybe Eike can clarify?

-- 
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/20210702/5258a4be/attachment.htm>