Oh, sorry, it seams that the sheet was created using my default language preferences. I suppose this can be easyly changed, but I need to see how.
As you say, there is a "CONTAR.SI" equivalent to "COUNTIF". I hate this of translating commands of language programs/Excel. It's a source of problems and the effort to learn one word or other is mainly the same, having you to learn again if you work in other language. Inherited bad ideas...
Hey, no problem, it makes sense. File::Settings:: can change both the locale and the time zone. That should be the responsibility of whoever wants to make a copy to edit.
I also tried a trick with my local copy. I wrote a function in the English locale then converted to Spanish. It turns out
=countif(c3:c21,"x")
which works in English locale doesn't work, but
=countif(c3:c21;"x")
which it's converted to, works in the Spanish locale. Grammar police, eh?
