DateTime formatting handling

Mar 25, 2010 at 2:39 PM

I am having some troubles to get a time value from a cell formatted using "#h:mm AM/PM".  In excel, it displays 2:00 PM.  But, when I get it from HSSFDataFormatter.FormatCellValue, it gives back "2:00 p" instead.  Is there a way to reserve the excel format?  I have also looked into the formatter code.  The implementation using a SimpleDateFormat seems to make this decision (i.e. PM vs p) as designed.  This is kind of confusing.  I am wondering is this effect desired?