Bug 53823 - FORMATTING: Date input
Summary: FORMATTING: Date input
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA (target:
Depends on:
Reported: 2012-08-20 06:51 UTC by dallaw1948
Modified: 2016-04-17 18:14 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description dallaw1948 2012-08-20 06:51:41 UTC
Problem description: On entering date as d/m in cell formatted as date, cell does not show in expected format

Steps to reproduce:
1. Format cell as date (say) 31 Dec 99
2. Input date in form 20/8....
3. ....

Current behavior:Cell remains showing 20/8

Expected behavior:20 Aug 12

Platform (if different from the browser): 
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20100101 Firefox/14.0.1
Comment 1 Hashem Masoud 2012-08-23 20:28:34 UTC
(In reply to comment #0)
Works for me. I followed the steps you listed and I got the exact date which I had specified in "Format Cellss".

Tested with: Version (Build ID: 932b512)
Comment 2 dallaw1948 2012-08-29 04:51:17 UTC
Uninstalled ver, and installed NO other changes made to computer, and the bug disappeared. therefore, it would appear to me to be in
Comment 3 Jean-Baptiste Faure 2012-08-29 05:00:32 UTC
Seems to be a duplicate of bug 52240
Comment 4 mahfiaz 2016-04-17 18:14:00 UTC
See Tools → Options → Language settings → Languages → Locale setting and Date acceptance patterns.

For Estonian (my language) the patterns are:  D.M.Y;D.M;D. M;D.M.;D. M.
For English (USA) they are:  M/D/Y;M/D

Enter your own version if these do not suit you. If your input does not match any of these, it is probably treated as text.

Feel free to reopen if this is not the case.