EXCEL FORMULAS: Problems With Language

Belias · 2007-06-26

I launch a process which create formulas in excel cells.
The problem is that if I have an english excel and i try to put an italian formula ('SOMMA' instead of 'SUM') excel doesn't recognise it.
How can I avoid this?
(I don't want to use an option to choose the language and then create both formula string).

Luc_VanDyck · 2007-06-26

I have used

ExcelAppl.International(1)

to know the country/language (ExcelAppl is a variable pointing to 'Microsoft Excel 12.0 Object Library'.Application).

List of values it returns:

Language        Country code    Countries/regions
-------------------------------------------------------------
   Arabic                966       (Saudi Arabia)
   Czech                 42        (Czech Republic)
   Danish                45        (Denmark)
   Dutch                 31        (The Netherlands)
   English               1         (The United States of America)
   Farsi                 982       (Iran)
   Finnish               358       (Finland)
   French                33        (France)
   German                49        (Germany)
   Greek                 30        (Greece)
   Hebrew                972       (Israel)
   Hungarian             36        (Hungary)
   Indian                91        (India)
   Italian               39        (Italy)
   Japanese              81        (Japan)
   Korean                82        (Korea)
   Norwegian             47        (Norway)
   Polish                48        (Poland)
   Portuguese (Brazil)   55        (Brazil)
   Portuguese            351       (Portugal)
   Russian               7         (Russian Federation)
   Simplified Chinese    86        (People's Republic of China)
   Spanish               34        (Spain)
   Swedish               46        (Sweden)
   Thai                  66        (Thailand)
   Traditional Chinese   886       (Taiwan)
   Turkish               90        (Turkey)
   Urdu                  92        (Pakistan)
   Vietnamese            84        (Vietnam)

This way, you don't need to ask the user which language version they use.

EXCEL FORMULAS: Problems With Language

Answers

Categories