Bug in recognizing Italian names of countries

Copper Contributor

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.

 

Dario_de_Judicibus_0-1671555186383.png

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.

 

Dario_de_Judicibus_1-1671555274536.png

 

Any idea why?

 

0 Replies