News for hackers. Stuff that matters.
Re:Microsoft Excel’s 35th birthday by dfox on Friday October 02, 2020 @10:57AM (#24663294)
Excel's notion of what is "CSV" and syntax of its formula language is locale dependent for as long as I care about that. Notably, for locales that use ',' as decimal point excel uses semicolons as separators in both its "C"SV format and formulas.

What changed in last few version is that excel started to distinguish whether you are "opening" an CSV file (eg. by double clicking it) or "importing" it and the former tends to lead to various kinds of random breakage in presence of the aforementioned (mis-)feature.

There are no comments on this comment yet.