You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/03/09 01:03:47 UTC

DO NOT REPLY [Bug 119038] New: 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

https://issues.apache.org/ooo/show_bug.cgi?id=119038

             Bug #: 119038
        Issue Type: DEFECT
           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
    Classification: Application
           Product: Spreadsheet
           Version: OOo 3.3 RC9
          Platform: PC
        OS/Version: Windows 7
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: formatting
        AssignedTo: ooo-issues@incubator.apache.org
        ReportedBy: cdybus@wi.rr.com


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.

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

[Bug 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

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119038

Dan <dd...@butler.edu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ddewar@butler.edu

--- Comment #4 from Dan <dd...@butler.edu> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

DO NOT REPLY [Bug 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

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119038

Marcus <ma...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|OOo 3.3 RC9                 |OOo 3.3

--- Comment #1 from Marcus <ma...@apache.org> 2012-03-09 20:24:25 UTC ---
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?

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

[Bug 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

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119038

--- Comment #5 from Dan <dd...@butler.edu> ---
Created attachment 80189
  --> https://issues.apache.org/ooo/attachment.cgi?id=80189&action=edit
Dates turned into Fractions

-- 
You are receiving this mail because:
You are the assignee for the bug.

DO NOT REPLY [Bug 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

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119038

urmasd <da...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |davian818@gmail.com

--- Comment #3 from urmasd <da...@gmail.com> 2012-03-13 12:46:48 UTC ---
Sounds like ligature issue, which font is used?

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

DO NOT REPLY [Bug 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

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119038

brinzing <br...@openoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |brinzing@openoffice.org

--- Comment #2 from brinzing <br...@openoffice.org> 2012-03-10 15:41:47 UTC ---
i can not confirm this issue, could you please 
attach an example document?

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

[Bug 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

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119038

Rob Weir <ro...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         QA Contact|                            |syamala.sai@gmail.com

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 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

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119038

saisyamala <sy...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
     Ever confirmed|0                           |1

--- Comment #6 from saisyamala <sy...@gmail.com> ---
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)

-- 
You are receiving this mail because:
You are the assignee for the bug.