|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | 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 | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Calc | Reporter: | cdybus | ||||
| Component: | formatting | Assignee: | AOO issues mailing list <issues> | ||||
| Status: | CONFIRMED --- | QA Contact: | saisyamala <syamala.sai> | ||||
| Severity: | Normal | ||||||
| Priority: | P3 | CC: | davian818, ddewar, oliver.brinzing | ||||
| Version: | OOo 3.3 | ||||||
| Target Milestone: | --- | ||||||
| Hardware: | PC | ||||||
| OS: | Windows 7 | ||||||
| Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
| Developer Difficulty: | --- | ||||||
| Attachments: |
|
||||||
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) |
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.