<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><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">143165</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>[EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.1.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>minor
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>pox_ox2@yahoo.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=173317" name="attach_173317" title="5-D_bug.ods (example data. filesize 13kB)">attachment 173317</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=173317&action=edit" title="5-D_bug.ods (example data. filesize 13kB)">[details]</a></span>
5-D_bug.ods (example data. filesize 13kB)
Reproduction procedure:
In any unformatted (General) empty cell, type "5-d" directly without the
doublequotes.
(five hyphen dee)
Expected result:
Cell value will become implicit text type '5-d, displayed as 5-d
Actual result:
Cell value becomes date type 2021/07/05 (5th of July, 2021),
displayed "7月5日" on my instance.
My environment:
The date of experiment: 2nd of July, 2021
Windows 10 64bit in Japanese mode
Libre Calc: UI:English(USA), locale:Japanese
I Think I have turned off all the autochange switches, as much as possible.
(If there already is a user switch to turn this feature off, it is too
difficult to find.)
Reproducibility:
100% (tested over 30 times)
Notes:
* The range of numbers where this happens is only 1 to 12. "13-d" gives
"13-d".
1-d gives 2021/07/01 and so on.
* The "d" part can be either small "d" or capital "D".
* "/" (slash) in the place of "-" (hyphen) gives the same date.
* Among the several other alphabets I tried, none behaved similarly.
* Can be either direct typed into the cell, or typed into the edit box.
* Can be either typed in by keyboard or pasted from clipboard.
* Actually, the cell doesn't have to be empty. Just type in.
* Behavior differs by cell format:
Date mode: Same date
E+, Currency mode: Some number (probably date code)
% mode: "5-d%"
* Microsoft Excel 2000 and 365 doesn't show this behaviour. "5-d" is just
"5-d".
Very strange.</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>