Bug 45246

Summary: Built In Date format
Product: POI Reporter: Rick <Patrick.Morgan>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED WORKSFORME    
Severity: normal    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   

Description Rick 2008-06-20 10:57:27 UTC
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.
Comment 1 Nick Burch 2008-07-10 16:02:14 UTC
Any chance you could upload a spreadsheet where this is happening, so we have something to test against?
Comment 2 Nick Burch 2008-09-21 11:36:18 UTC
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