Thanks for letting us know that you were able to confirm my findings with regard to Excel at least. Sadly, I must say that I was not surprised OpenOffice could not work with those format strings. There is something about them that is unique, or at least 'special', to Excel I think and it is not transferrable between the applications. It might be possible to find one of the format stings Excel uses that OpenOffice Calc can parse. Did you experiment with any of the other defaults for the Date type?
-- View this message in context: http://apache-poi.1045710.n5.nabble.com/Set-cell-type-to-Date-tp5537937p5541288.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]
