incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject 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
Date Fri, 09 Mar 2012 00:03:47 GMT
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.
Mime
View raw message