Bug 53823 - FORMATTING: Date input
Summary: FORMATTING: Date input
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA (target:3.6.0.4)
Keywords:
Depends on:
Blocks:
 
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:

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 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 3.6.0.4 (Build ID: 932b512)
Comment 2 dallaw1948 2012-08-29 04:51:17 UTC 
Uninstalled ver 3.6.0.4, and installed 3.5.6.2. NO other changes made to computer, and the bug disappeared. therefore, it would appear to me to be in 3.6.0.4
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.