Bug 61596

Summary: FORMATTING: Error in formatting dates
Product: LibreOffice Reporter: merlin.magicus
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal    
Priority: medium    
Version: 4.0.1.1 rc   
Hardware: Other   
OS: Windows (All)   
Whiteboard: BSA
Crash report or crash signature: Regression By:

Description merlin.magicus 2013-02-28 09:15:54 UTC 
Problem description: 

I have installed version 4.0.1.1 (Build ID: 2c0c17a6e4bee0ee28131ea4bdc47edc700d659).

If I enter 02/02/13, I get the format established 02/02/2013. But in 3.6, if I enter 2-2 in a cell formatted as a date, I get 02/02/2013 (current year). In version 4.0.1.1 this behavior is not included.

I tried also resetting the user profile but the behavior is the same.

Steps to reproduce:
1. Formatting a cell as a date
2. Enter in that cell: 2-2

Current behavior:

When you enter 2-2 in a date formatting cell you got 2-2. In this cell, if you enter 2/2 you got 02/02/2013. 

Expected behavior:
In version 3.6, the behavior was the same with "-" or "/". If you enter 2-2 or 2/2, get 02/02/2013, according to the selected format.

Operating System: Windows 7
Version: 4.0.1.1 rc
Comment 1 merlin.magicus 2013-02-28 17:27:50 UTC 
The problem is resolved if you add new paterns in Tools-Options-Language Settings-Languages in field Date accetpance patterns.