> Presumably one uses the same locale everywhere?

It depends.

> So switching by locale should not be a problem?

Until you get an Excel file written in another locale. The coolest one i had was one with Japanese formulas.