Apache OpenOffice (AOO) Bugzilla – Issue 119038
date 3/4/2012 treated as ¾/2012 when date form MM/DD/CCYY. DATE 1/2/2012 treated as ½/2012 when date format MM/DD/CCYY
Last modified: 2013-02-06 05:26:43 UTC
Using OO spreadsheet with OS Windows 7: 1) I format a cell for date format MM/DD/CCYY. 2) I enter the date '3/4/2012' WITHOUT the leading zeros in day and month. 3) The date in the cell appears as '¾/2012' (software treats the MM/DD as the fraction three-quarters. 4) With cell formatted with date format MM/DD/CCYY: 5) I enter the date '1/2/2012' WITHOUT the leading zeros in day and month. 6) The date in the cell appears as '½/2012' (software treats the MM/DD as the fraction one-half. 7) Same issue with the date entered as '1/4/2012' (no leading zeros in MM/DD). Date appears as '¼/2012' (Month and day treated as fraction one-quarter. Thank you, Carl Dybus cdybus@wi.rr.com.
I've tried to reproduce the issue with OOo 3.3 on Linux. When I format the cells with "MM/DD/CCYY" then I get, e.g., "04/03/CC12" as result. When I format with "MM/DD/YYYY", then I get, e.g., "3/4/2012". Is there anything else one has to know?
i can not confirm this issue, could you please attach an example document?
Sounds like ligature issue, which font is used?
AOO341m1(Build:9593) - Rev. 1372282 Windows 7 / 32-bit I was able to replicate this issue. I have found the exact same thing. When entering the date '3/4/2012' into a 'MM/DD/CCYY' field it turns the 3/4 into a fraction. Same results with the 1/4 and 1/2. I was not able to get the same results for any other similar dates like '1/5/2012' or '1/3/2012'. They correct to '01/05/2012' and '01/03/2012' as expected. This could become a very pain issue for some users who are frequently entering dates. I have attached my document for further clarification.
Created attachment 80189 [details] Dates turned into Fractions
Tested with version 3.5.0 on windows 7. Was able to reproduce the same issue. Entering the date '3/4/2012' WITHOUT the leading zeros in day and month makes them appear like '¾/2012' (software treats the MM/DD as the fraction three-quarters)