News for hackers. Stuff that matters.

A comment on Why does Google use location for language rather than browser settings?. Parent comment

Re:Why does Google use location for language rather than bro... by m_st on Friday March 11, 2022 @08:28AM (#30639583)
Regarding Excel: Watch out with multi language setups! I was working with an English iPhone, an English Windows PC and a Swiss German Mac on an Excel file stored on One Drive. Editing sometimes in Excel and sometimes in Excel Online.

Result: Broken data due to SUM/SUMME/etc formulas, broken phone number recognition and (worst) broken dates.

What a mess!

[ Parent | on HN ]
Re:Why does Google use location for language rather than bro... by ProblemFactory on Friday March 11, 2022 @09:43AM (#30640485)
And broken CSV files.

In some European locales Excel switches from importing/exporting Comma Separated Values to Semicolon Separated Values with comma acting as the decimal point.

[ Parent | on HN ]
Re:Why does Google use location for language rather than bro... by mobilio on Friday March 11, 2022 @06:13PM (#30647294)
I'm also victim of this.

It can be fix if you do import from file and then manually select separator.

But this was need to be done every. single. time.

[ Parent | on HN ]