I've Windows XP. Went to Control Panel -> Regional Settings and changed the locale there to 'French' and 'German'. For a cell with format set to '#,###.##', the format is now shown as '##.###,##' for German locale and '## ###,##' for French Locale respectively. So based on the language setting Excel automatically uses the appropriate group separator and decimal symbols.
So it seems that as far as Excel is concerned, it'd suffice to specify the format using the English symbols ( kind of de-facto standard for excel ). and leave it to the user's locale settings to use appropriate equivalent symbols for that locale. -Rk -----Original Message----- From: Cédric Bosdonnat [mailto:[email protected]] Sent: Freitag, 27. August 2010 17:46 To: POI Users List Subject: Re: Number Format for German/French locale ? Hi Radhakrishnan, On Fri, 2010-08-27 at 17:02 +0530, Jankiraman, Radhakrishnan wrote: > For some languages, the decimal and group separator characters are different. > For e.g., 3141.59 would be 3.141,59 for German locale and 3 141,59 for French > locale. How do I tell excel to use these formats ? The OOXML reference > documentation says that '.' is the decimal separator and ',' is the group > separator. Can' this be changed ? > > My OS locale is set to US English. I do have a test case where I try to set > the number format as in java ( i.e. #.###,## for German and # ###,## for > French ). But it isn't working. Is there a way to get around this ? I have no knowledge of the Excel file format, but in Word files, you have a lid property setting the language correctly. The separators are computed from this property. Regards, -- Cédric Bosdonnat Go-oo hacker http://go-oo.org OOo Eclipse Integration developer http://cedric.bosdonnat.free.fr --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
