International Dates in Excel??

[DrDad <dr...@bellatlantic.net>]

Is there a way to set a dataformat in a CellStyle to print dates in
international format? That is to show the date according to where the
machine is that's opened the file? Excel will do this, but even the Excel
documentation doesn't say what the format is. 

--
View this message in context: http://apache-poi.1045710.n5.nabble.com/International-Dates-in-Excel-tp4543125p4543125.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: International Dates in Excel??

[Nick Burch <ni...@alfresco.com>]

On Fri, 1 Jul 2011, DrDad wrote:
> Is there a way to set a dataformat in a CellStyle to print dates in 
> international format? That is to show the date according to where the 
> machine is that's opened the file?

Do you mean the "magic" date formats which change based on the locale of 
the machine?

If so, at the moment POI will only give you the real date format that is 
written into the file, which is normally in the US format. The other 
(localised) format strings don't get written to the file, so we don't have 
them to use, sorry. All we can do at the moment is show you the file 
value.

That said, if someone wanted to spend a couple of hours swapping their 
excel into different locales and recording what the magic date formats 
become, I think we wouldn't be adverse to recording that somewhere!

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org