Forum Discussion
Dario_de_Judicibus
Dec 20, 2022Copper Contributor
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