Comment by mattmanser
2 days ago
1.01 in US === 1,01 in EU
1.01, "hi", CSV has problems, "1.01"
1,01, "hi", Yes it really does, "1,01"
See the problem now?
Your operating system cannot solve this problem.
2 days ago
1.01 in US === 1,01 in EU
1.01, "hi", CSV has problems, "1.01"
1,01, "hi", Yes it really does, "1,01"
See the problem now?
Your operating system cannot solve this problem.
CSV already solved this problem with quotes. Maybe not the most convenient solution for some users but that's no excuse for the Excel behavior of making up a different format depending on the locale.
Excel really doesn't care what users think. I mean, in biology, we've already had to change the names of genes to accommodate Excel's auto-date conversion routines. So, why would it care to have globally consistent CSV formats?
Is this 2025? Why would any software safe it invalid like that to begin with?
Not all of EU though. I am European and I never used "," anywhere yet people understood.
I don't understand the down-votes, but okay, have it your way, lmao. Someone really hates dots.
I guess the downvotes are because you also didn't understand the context.
It's not about people, it's about the Windows locale setting and how MS Excel interprets a CSV-file when you doubleclick it
1 reply →