Bug 140348 - Apparent problem in cell formatted as Date
Summary: Apparent problem in cell formatted as Date
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-02-11 15:52 UTC by Dave
Modified: 2021-02-11 16:17 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.