Hacker News Reader

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!

View on HN

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.

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.

Reply on news.ycombinator.com