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: [email protected] For additional commands, e-mail: [email protected]
