https://bugs.documentfoundation.org/show_bug.cgi?id=173670
Bug ID: 173670
Summary: Entering 20 Jan does not work in a Date formatted cell
Product: LibreOffice
Version: 24.2.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 208673
--> https://bugs.documentfoundation.org/attachment.cgi?id=208673&action=edit
A1 cell date issue
Could someone reproduce in latest release?
Cell A1 is formatted ISO 8601 YYYY-MM-DD
1. Type: 20 Jan <enter>
2. Observe it shows 2020-01-01
^^ This is the issue
Expected: 20 Jan 2026
Clearly it is interpreting it thinking someone does not want 20th January, but
the year 20, January. However no one refers to dates like this.
I'll attach the test case file
Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.6
Calc: threaded Jumbo
--
You are receiving this mail because:
You are the assignee for the bug.
