Bug 45246 - Built In Date format
Summary: Built In Date format
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2008-06-20 10:57 UTC by Rick
Modified: 2008-09-21 11:36 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
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