| ▲ | mattmanser 5 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. |
|
| ▲ | account42 5 days ago | parent | next [-] |
| 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. |
| |
| ▲ | mbreese 5 days ago | parent [-] | | 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? |
|
|
| ▲ | herbst 5 days ago | parent | prev | next [-] |
| Is this 2025? Why would any software safe it invalid like that to begin with? |
|
| ▲ | johnisgood 5 days ago | parent | prev [-] |
| Not all of EU though. I am European and I never used "," anywhere yet people understood. |
| |
| ▲ | johnisgood 5 days ago | parent [-] | | I don't understand the down-votes, but okay, have it your way, lmao. Someone really hates dots. | | |
| ▲ | rickdeckard 5 days ago | parent [-] | | 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 | | |
|
|
