Bug 53098 - FORMATTING: When entering dates 1/2/* or 1/4/* system interpretes first 2 elements (day/month or month/day according to language) as fractions.
Summary: FORMATTING: When entering dates 1/2/* or 1/4/* system interpretes first 2 ele...
Status: RESOLVED DUPLICATE of bug 33899
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.5.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-08-03 15:34 UTC by oconcepcion
Modified: 2013-03-06 21:28 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
3 images related. (238.46 KB, application/pdf)
2012-08-03 15:34 UTC, oconcepcion 		Details
View All 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 oconcepcion 2012-08-03 15:34:26 UTC 
Created attachment 65094 [details]
3 images related.

Problem description: 

Steps to reproduce:
1. Type date with 1 and 2 or 1 and 4 as first 2 elements.
2. ....
3. ....

Current behavior:
Shows: See screenshot
Expected behavior:
For spanish: January/second/"year" or April/fourth/"year"
For English: January/second or fourth/"year" 
Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20100101 Firefox/14.0.1
Comment 1 oconcepcion 2012-08-03 15:52:07 UTC 
Comment on attachment 65094 [details]
3 images related.

Image 1: 2 cells showing error and format window showing correct format.
Image 2: Function Wizard window (dates entered as cell address) showing calculation error.
Image 3: Function Wizard window (dates typed directly). System takes dates as calculations (1/4/10=0.025) - (1/2/10=0.05) = -0.025 I include this comment because I think program should recognize or accept format of entry according to function (date function)
Comment 2 oconcepcion 2012-08-03 16:04:31 UTC 
Comment on attachment 65094 [details]
3 images related.

Image 1: 2 cells showing error and format window showing correct format.
Image 2: Function Wizard window (dates entered as cell address) showing
calculation error.
Image 3: Function Wizard window (dates typed directly). System takes dates as
calculations (1/4/10=0.025) - (1/2/10=0.05) = -0.025 I include this comment
because I think program should recognize or accept format of entry according to
function (date function)

 Note: Dates in Spanish would be February or April/first/"year"
Comment 3 Jean-Baptiste Faure 2012-08-04 17:55:22 UTC 
Not a bug, only a side-effet of auto-correction.
Two solutions:
1/ disable autocorrection
2/ type two digits when you want dates : 01/02/*

Best regards. JBF
Comment 4 Lionel Elie Mamane 2013-03-06 21:28:44 UTC 

*** This bug has been marked as a duplicate of bug 33899 ***