Bug 140348

Summary: Apparent problem in cell formatted as Date
Product: LibreOffice Reporter: Dave <davejgreen.mail>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED NOTABUG    
Severity: normal CC: himajin100000
Priority: medium    
Version: 7.0.4.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description Dave 2021-02-11 15:52:32 UTC 
Description:
Libra Calc set to English date format
Column set as Date dd/mm/yy
enter date as d/m only
1/2 - displays as 1/2, same with 1/4 and 3/4
Should surely be 01/02/21 etc.
I believe all other dates display as expected
 

Steps to Reproduce:
1.enter 1/2

2.
3.

Actual Results:
1/2 displayed


Expected Results:
01/02/21 for this year


Reproducible: Always


User Profile Reset: No



Additional Info:
only happens with 1/2 (Feb), 1/4 (Apr), 3/4 (Apr)
Comment 1 Eike Rathke 2021-02-11 16:17:32 UTC 
That's a result of AutoCorrection. Either press Ctrl+Z immediately after Enter, which undoes the unwanted correction and re-enters the original input which then is accepted as date, or disable under menu Tools -> AutoCorrect Options.., either by removing single replacements or disabling use of replacement table in the Options tab.