Hi Joe,

On Wednesday, 2007-02-21 10:18:50 -0500, Joe Smith wrote:

> >At least the Dutch version of Excel uses the semicolon as a list 
> >separator. Maybe because in Europe we use the comma as decimal separator 
> >fractions? So for me it's as natural as it gets. ...
> 
> Good point. Sorry, I always forget about you wacky Europeans with your 
> commas all mixed up ;-)

You might be interested to hear that this isn't about wacky Europeans
vs. wacky US-Americans ;-)

Listing locales supported by OOo:

71 locales use the dot as decimal separator:

af_NA af_ZA ak_GH am_ET bn_BD bn_IN cy_GB de_CH de_LI dz_BT en_AU en_BZ
en_CA en_GB en_IE en_IN en_JM en_NA en_NZ en_PH en_TT en_US en_ZA en_ZW
es_DO es_EC es_GT es_HN es_MX es_NI es_PA es_PR es_SV fr_CH ga_IE gsc_FR
gu_IN he_IL hi_IN it_CH ja_JP ka_GE kn_IN ko_KR ku_TR lo_LA ml_IN mr_IN
ms_MY ne_NP nr_ZA nso_ZA or_IN pa_IN ss_ZA st_ZA sw_TZ ta_IN te_IN th_TH
ti_ER tn_ZA ts_ZA ve_ZA xh_ZA zh_CN zh_HK zh_MO zh_SG zh_TW zu_ZA

73 locales use the comma as decimal separator:

az_AZ be_BY bg_BG br_FR bs_BA ca_ES cs_CZ cv_RU da_DK de_AT de_DE de_LU
el_GR eo es_AR es_BO es_CL es_CO es_CR es_ES es_PE es_PY es_UY es_VE
et_EE eu fi_FI fo_FO fr_BE fr_CA fr_FR fr_LU fr_MC fur_IT gl_ES hr_HR
hu_HU ia id_ID is_IS it_IT kk_KZ kl_GL km_KH ky_KG la_VA lb_LU lt_LT
lv_LV mk_MK mn_MN nb_NO nl_BE nl_NL nn_NO no_NO pl_PL pt_BR pt_PT ro_RO
ru_RU rw_RW sh_YU sk_SK sl_SI sr_YU sv_FI sv_SE tg_TJ tr_TR uk_UA vi_VN
wa_BE

Breaking that down to languages and countries results in the following.
Note that use by language may differ between countries in some cases, as
for Spanish and German, thus a language may be listed in both lists.

43 languages use the dot as decimal separator:

af ak am bn cy de dz en es fr ga gsc gu he hi it ja ka kn ko ku lo ml mr
ms ne nr nso or pa ss st sw ta te th ti tn ts ve xh zh zu

55 languages use the comma as decimal separator:

az be bg br bs ca cs cv da de el eo es et eu fi fo fr fur gl hr hu ia id
is it kk kl km ky la lb lt lv mk mn nb nl nn no pl pt ro ru rw sh sk sl
sr sv tg tr uk vi wa

46 countries use the dot as decimal separator:

AU BD BT BZ CA CH CN DO EC ER ET FR GB GE GH GT HK HN IE IL IN JM JP KR
LA LI MO MX MY NA NI NP NZ PA PH PR SG SV TH TR TT TW TZ US ZA ZW

57 countries use the comma as decimal separator:

AR AT AZ BA BE BG BO BR BY CA CL CO CR CZ DE DK EE ES FI FO FR GL GR HR
HU ID IS IT KG KH KZ LT LU LV MC MK MN NL NO PE PL PT PY RO RU RW SE SI
SK TJ TR UA UY VA VE VN YU

So who's wacky now? ;-)

You may lookup language codes in ISO 639
http://www.loc.gov/standards/iso639-2/php/English_list.php
and country codes in ISO 3166
http://www.iso.org/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html

  Eike

-- 
 OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer.
 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS
 Please don't send personal mail to this [EMAIL PROTECTED] account, which I use 
for
 mailing lists only and don't read from outside Sun. Thanks.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to