Could this not be simple confusion between type and format? Using Excel, when you choose to format a cell, the application will open the 'Format Cells' dialog box for you to make selections. If you click on the Date 'Category' then the display will change to show you a Type and a Locale combo box. The key, to my mind, is the range of options available to you in the Type combo box. If one of these does match your specific format, then the cell will appear to be a Date type cell. If not, then the only option left is for it to be a Custom formatted cell. Also, remember to distinguish between format and type; a Custom format cell can still ne a Date type cell.
So, if your preferred format of dd-MMM-yyyy is available by default in the Type box for the specific locale selected in the Locale combo box, then it is likely that the cell will show as a Date cell, otherwise it will be a Custom formatted cell. This is also the key, at least I think it is, to Nick's previous point about Locale's being important, it affects the set of Types. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-Date-cells-with-different-date-formats-generates-Excel-cell-with-custom-data-type-insteade-tp5711889p5711898.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
