>> Where is there an outline of which locales provide which formatting? I >> have gone through quite a bit of the docs as support.openoffice.org >> but I find nothing. >> > Any number format dialog in this office suite shows all the built-in > formattings with format codes for all the built-in locales and for the > userdefined ones. >
It seens that there is an error, in that the Danish locale uses dd-mm-yy format in OOo whereas the Posix Danish locale uses yyyy-mm-dd. Or I may be mistaken, but I think not. Likewise, the OOo Swedish locale uses yy-mm-dd whereas I think, but am less certain, that the Swedish Posix locale is also yyyy-mm-dd. The only locales configured for yyyy-mm-dd (which is an ISO standard, by the way) are Hungarian and Lithuanian. Both use the comma for decimals, so they are out for me. How does a user create a custom locale and make it the default? >>> Alternatively, you may decide to use the "Default" locale, which defaults >>> to >>> the same "en-US style" on every US American system (12/31/1999 and >>> 1,234.99), the same Hebrew style on every Hebrew system (31/12/1999 and >>> 1,234.99) and the same Swedish style on every Swedish system (1999-12-31 >>> and >>> 1 234,99). >> >> Yes, I would like this very much. In fact, I have set them as Default. >> However, this is not producing the for specified in my locale. >> > It should work. > Should being the key work here. It does not. >>> The office user may set his/her preferred default locale in the general` >>> locale settings or let OOo read one distinct locale from the system's >>> general language. >> >> I think that I see. I set the Language Settings -> Languages -> Local >> Setting as Default, and it reads LANG, then formats everything (paper >> size, time, measurement) as if they were the same as that of LANG as >> well. I have two comments on this: >> 1) The other locale settings should not be assumed to be the same, >> they are configurable separately for a reason. >> 2) It does not work. I still get US date formats, not my locale's date >> format. >> >> > Oh, well. Again, I assumed that it should work like this. > > OK, let's see. > I set my application locale to "Default" and close the office. > $> LANG=he_IL.utf8 soffice -calc > My /usr/bin/soffice points to Sun's compilation of OOo 3.1.1 in /opt/ >> >> (process:17312): Gdk-WARNING **: locale not supported by C library >> >> (soffice:17312): Gtk-WARNING **: Locale not supported by C library. >> Using the fallback 'C' locale. > Of course, you would have to build that locale. Are you on a debian-based system? There is a tool for that, something like locale-gen I think. > Anyway, the office starts with a new spread in some English GUI. > I type 1/12/2009 which gives the right value for this months 1st of December > in a date format that looks like the British one I typed into the cell. > The cell formatting dialog shows number format language "Default" which > obviously defaults to Hebrew since the date section offers me a lot of date > formats that look interesting for me as a goy. > I doubt that it would be Hebrew as the GTK error show that locale is not supported on your system, and the Hebrew date format should in fct look familiar to you. The everyday calendar used in Israel is the same Gregorian calendar that you are used to. > OK, close this and try another flavour.: > LANG=he_IL.UTF-8 /usr/lib/openoffice/program/soffice -calc >> >> I18N: Operating system doesn't support locale "" >> I18N: Operating system doesn't support locale "en_US" > > /usr/lib/openoffice/program/soffice -calc points to Ubuntu's compilation of > OOo 3.0.1. This behaves in the same way as the previously tested Sun > version. > > Sorry, I can not reproduce the misbehaviour you have outlined, but I found > another reason why OOo uses it's own set of locale options independently > from the system: My system is not prepared for this locale as the error > messages indicate, but OOo offers all the needed options to write Hebrew > documents (if I could). > Thanks, Andreas, but Hebrew support is far different than yyyy-mm-dd support! yyyy-mm-dd is not the default date format for Israel, rather, I think it is the British yy/mm/dd as you are familiar with. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
