<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - [EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143165">bug 143165</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>erack@redhat.com
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - [EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143165#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - [EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143165">bug 143165</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>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?</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>