Forum Discussion

Dario_de_Judicibus's avatar
Dario_de_Judicibus
Copper Contributor
Dec 20, 2022

Bug in recognizing Italian names of countries

It looks like there is a bug in Data Types, Geography, in Excel. If I write in a sheet

 

Italia
Francia
Inghilterra
Germania
Paesi Bassi
Spagna
Portogallo
Grecia

 

that is, the Italian names of Italy, France, England, Germany, Nederland, Spain, Portugal, and Greece, I select all of them and then I mark them as Geographic data, Excel recognize all of them but England and Spain.

 

However, if I use UK instead of Inghilterra and Spain (in English!) instead of Spagna, that is

 

Italia
Francia
UK
Germania
Paesi Bassi
Spain
Portogallo
Grecia

 

Excel recognizes those two too, and change them to Regno Unito and Spagna. The strange behavior is that it uses Spagna as I did before, but only if I write Spain.

 

 

Any idea why?

 

No RepliesBe the first to reply

Resources