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]
