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.