You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/06/20 19:57:28 UTC

DO NOT REPLY [Bug 45246] New: Built In Date format

https://issues.apache.org/bugzilla/show_bug.cgi?id=45246

           Summary: Built In Date format
           Product: POI
           Version: unspecified
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: Patrick.Morgan@ncogroup.com


I'm using Excel 2003 with a standard Date cell format of "*3/14/2001".  This is
format index 14 (according to ExtendedFormatRecord).  When I call
HSSFDataFormat.getBuiltinFormat(14), I get mm/dd/yy.  I was expecting
mm/dd/yyyy.

In another related issue, I use date format "3/14/2001".  This format should be
a built in format, but it's index returns as 165.  When I get the FormatRecord,
the format string shows as "m/d/yyyy;@".  I was expecting m/d/yyyy.


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

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 45246] Built In Date format

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


Nick Burch <ni...@torchbox.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |RESOLVED
         Resolution|                            |WORKSFORME




--- Comment #2 from Nick Burch <ni...@torchbox.com>  2008-09-21 11:36:18 PST ---
Closing as no further information has been provided. Please re-open if you do
have the spreadsheet

In general though, newer versions of excel do seem to like using more complex
"user defined" formats, instead of the older built in ones


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

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 45246] Built In Date format

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


Nick Burch <ni...@torchbox.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO




--- Comment #1 from Nick Burch <ni...@torchbox.com>  2008-07-10 16:02:14 PST ---
Any chance you could upload a spreadsheet where this is happening, so we have
something to test against?


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

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org